This article describes how to convert the time zone in MySQL by using the CONVERT_TZ function.
By default, A2 Hosting's servers use one of the following time zones:
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' );
Subscribe to receive weekly cutting edge tips, strategies, and news you need to grow your web business.
No charge. Unsubscribe anytime.