Mysql timezone

[Arcanum417]

On the Mysql server I migrated to I cannot change the timezone. Timezone could be setup session by session or globally. It would be nice to set timezone for the addon part and timezone for the php part.

[alexcroox]

The addon part uses NOW() for its date time saving which means it will use whatever the MySQL db timezone is set to. To get the php part to match that, set the timezone in config.php

[Arcanum417]

Yeah, I got that. However I cannot change Mysql server timezone but I want to show Here diffrent timezone as is saved on Mysql server

[Arcanum417]

It looks like it would be easiest to manipulate the value while rendering the table. So backend still works with with Mysql timezone but you can set in config timezone for the frontend.