search

alexcroox / R3-Web

Website component for R3. Check branches for latest dev updates
https://github.com/alexcroox/R3
Other
25 stars 14 forks source link

Mysql timezone #11

Open Arcanum417 opened 7 years ago

Arcanum417 commented 7 years ago

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 commented 7 years ago

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 commented 7 years ago

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 commented 7 years ago

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.