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');|
Rs. 20,000 US$ 300
Today: Rs. 10,000 US$150
Course Duration: 30 hrs
Posted on: December 31, 2008 If you enjoyed this post then why not add us on Google+? Add us to your Circles