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.

On shared servers, you cannot change the default MySQL time zone, because this would affect other accounts on the server. However, you can convert the time zone used in DATE, TIME, and DATETIME fields by calling the CONVERT_TZ function as needed.

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' );
For a complete list of time zones, please visit https://en.wikipedia.org/wiki/List_of_tz_database_time_zones.

More Information

Get MySQL Hosting

Article Details

  • Level: Intermediate

Did you find this article helpful? Then you'll love our support. Experience the A2 Hosting difference today and get a pre-secured, pre-optimized website. Check out our web hosting plans today.

Usamos cookies con el fin de personalizar para usted nuestro sitio Web y analizar el uso de éste. Usted acepta esto haciendo clic en “Acepto” o al continuar usando el sitio Web. Hay más información sobre cookies en nuestra política de privacidad.