What is the downstream effect of changing AWS RDS instance default time Zone from UTC to EST?

238 Views Asked by At

We are using UTC time Zone as default in AWS RDS instance. All mysql databases are running in RDS instance following UTC. But based on the requirement I need to change UTC to EST so all DBs are running in EST. This is a trading platform and we suppose to go live in Production soon. We need to make sure we are alighted to EST time zone. We know how to do this based on AWS online documentation, but we are not sure if there would be any consequence or downstream effect if we change the AWS RDS default time zone from UTC to EST. If you changed this in your project, can you please share your thoughts. Also please share how we should handle US Daylight savings?

1

There are 1 best solutions below

3
On

Why do you need to change? The only difference is what the claim the current time is. Why can't you just display the time as UTC - 5 or whatever it is.

I would do some push back on and figure out why the time zone needs to even shift? Programming best practice is to use UTC if I'm not mistaken?