This article describes how to convert the time zone in MySQL by using the CONVERT_TZ function.
By default, A2 Hosting's servers are set to use the US Eastern 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' );