Home / server / Questions / 878702
In Process
Black Dynamite
Asked: 2017-10-17 06:16:03 +0800 CST

AWS RDS MySQL: Populate Timezone Tables

  • 772

I'm using an AWS RDS MySql (5.7.19) installation and I need to do some date conversions. Most docs say that you need to have the timezone tables populated, to do anything.

https://stackoverflow.com/questions/19023978/should-mysql-have-its-timezone-set-to-utc

Is there a way to set the timezone tables in this current setup?

I can do things like 

SELECT CONVERT_TZ( NOW(), @@session.time_zone, '-04:00' );

But I'm concerned about the daylight savings times coming into play.

Any help is greatly appreciated.

mysql

0 Answers