Can anyone suggest which timezone to set on AWS RDS in Alberta region.
We currently use America/Denver time zone, but that is going to fall back this Sunday night, but Alberta timezone is not changing
Thanks in advance
Can anyone suggest which timezone to set on AWS RDS in Alberta region.
We currently use America/Denver time zone, but that is going to fall back this Sunday night, but Alberta timezone is not changing
Thanks in advance
UTC
America/Edmonton is the one you want, it stays on MST year round so you won’t get the DST shift
I dont see America/Edmonton in the available timezones in AWS RDS Paramter Group
Why anything but UTC?
I am Canada central 1 and nothing uses any tz that is not UTC
You only ever want to store UTC. You always provide UTC to the backend. The backend should also use UTC. The visualization layer/frontend should be the one providing the time zone translation based on the user’s preference or business decision.
Always UTC for both the server and database.
This person is correct OP. You can choose whatever you want but UTC would be the best choice and save you a LOT of headaches down the road if you ever have to account for time changes again (as history would show us…) or users in different time zones etc. That way your “source of truth” is consistent and your frontend or app or whatever can massage the UTC time into whatever time zone the user is in.
This is correct. You should never use anything except UTC for storage and data transmission. Convert to another time zone if necessary only for human-readable display.
The only right answer.
UTC
UTC everywhere and avoid any time zone shenanigans
Everything should be set to UTC.
UTC
America/Edmonton, after a certain version of MySQL, should work - 8.4.11+.
Holy god, UTC. Render timezones in the presentation / app layer, or you will live to regret it.
You can make Google engineers of a certain era flinch by saying “Google Standard Time” if you need proof of this.
UTC, always UTC
UTC. Leave time conversion to display logic.
Always UTC
Time is an illusion anyway