The Tutorial illustrate you an example from 'Mysql Time Zone Conversion' that describes you about the time zone conversion.
CONVERT_TZ() is the function that is used for converting a date time value from one time zone to the other time zone.
dt:-This is the date which is to be converted.
from_tz:-This is the time zone which is to be converted
to_tz:-This is the time of the zone which is to be displayed in the table.
|SELECT CONVERT_TZ('2008-12-15 00:00:00','-06:00','+05:30');|
If you enjoyed this post then why not add us on Google+? Add us to your Circles
Liked it! Share this Tutorial
Discuss: Mysql Time Zone Conversion
Post your Comment