Knowledge Base

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