Where do you define the TimeZone, my records are 5 hrs ahead should be ESTi was manually setting @$TIME_ZONE = “America/New_York”; then removed it figuring didn’t need it
See Tools → Locale Settings in the help file.
There are two timezone settings:
- Tools → Locale Settings
- Tools → Advanced Settings → Database time zone (for SET TIME ZONE)
The server default timezone is UTC.
Every time we use CURRENT_TIMESTAMP in code or in database definition, or NOW in the code, we end up with server time of UTC.These two articles recommend storing all time as UTC on server:
kylekatarnls.medium.com/always-use-utc-dates-and-times-8a8200ca3164
kylekatarnls.medium.com/handle-dates-the-right-way-in-php-c215650fc4faWhat is the best/recommended strategy for entire PHPMaker code to work in a single timezone, for example Paris, without needing to worry about timezone and DST changes leaving all server date/time to UTC with minimum coding overhead. Is it enough to change Locale selection to Paris? Will Client-side automatically convert from UTC to locale with DST correction when displaying the date/time? Will Datepicker selection automatically convert to UTC when saving to server?Thank you for your guidance!
Post your settings for both options above (Tools → Locale Settings and Tools → Advanced Settings → Database time zone (for SET TIME ZONE)) for more discussion.