How to convert the time zone in MySQL

This article describes how to convert the time zone in MySQL by using the CONVERT_TZ function.

Using the CONVERT_TZ function

By default, A2 Hosting's servers use one of the following time zones:

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

However, you can convert the time zone used in DATE, TIME, and DATETIME fields by calling the CONVERT_TZ function.

For example, the following sample query shows how to convert the current date and time in the US Eastern time zone to the time zone for Paris, France:

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

  You can use the mysql program to connect directly to MySQL from the command line. Learn how here.

• Convert a MySQL database to UTF-8

  Learn how to convert a MySQL database’s character set to UTF-8 (Unicode) encoding.