21 October 2013

mysql timezones

Add the timezone names to the mysql table:

root@db1:~# mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root

mysql> CONVERT_TZ( 'datetime', 'from_timezone', 'to_timezone')

No comments:

Post a Comment