An specific timezone is not available on a RDS Aurora MySQL cluster

Asked Aug 06 '19 at 20:03

Active Aug 06 '19 at 23:26

Viewed 755 times

I have a database in RDS MySQL 5.7 instance and within the Parameters Groups I have defined the parameter "time_zone" as "America / Santiago", but now I want to migrate the database to an Aurora MySQL Serverless cluster (Running MySQL 5.6) but the timezone "America/Santiago" is not available within the "Allowed values".

What is appropriate in these cases so as not to have time_zone differences in the data?

edited Aug 06 '19 at 23:26

Tim

31,888
7
52
78

asked Aug 06 '19 at 20:03

FrancoVP

1

Run and store in UTC. Convert on the front-end. It'll save you an immense amount of grief in the long run. – ceejayoz Aug 06 '19 at 20:09
I was thinking in that, I think I will do it that way. – FrancoVP Aug 07 '19 at 13:55

An specific timezone is not available on a RDS Aurora MySQL cluster

0 Answers0