Converting the MySQL time zone

​

Using the CONVERT_TZ function

• US-based (Michigan) servers: US Eastern Time zone.
• Europe-based (Amsterdam) servers: Central European Time zone.
• Asia-based (Singapore) servers: Singapore Standard Time zone.

SELECT CONVERT_TZ( NOW(),'US/Eastern','Europe/Paris' );

​

More information

• For more information about time zone support in MySQL, please visit http://dev.mysql.com/doc/refman/5.0/en/time-zone-support.html.
• For more information about the CONVERT_TZ function, please visit http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_convert-tz.

​

Related articles

• Connecting to MySQL from the command line
• Converting a MySQL database to UTF-8
• Changing the time zone on a managed hosting account
• Managing MySQL databases, users, and tables from the command line
• Changing the time zone in the Linux shell
• Changing the time zone in webmail