Newsletter
Web development tips, marketing strategies and A2 Hosting news sent to your inbox.
Nuestra base de conocimientos sólo está disponible actualmente en inglés. Estamos en el proceso de traducir estas páginas y las publicaremos cuando estén disponibles.
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.
Table of Contents
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.
