Mysql Time Zone Conversion
The Tutorial illustrate you an example from 'Mysql Time Zone Conversion' that describes you about the time zone conversion.
SYNTAX:-CONVERT_TZ(dt,from_tz,to_tz)
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.
Query:-
SELECT CONVERT_TZ('2008-12-15 00:00:00','-06:00','+05:30'); |
Output:-
![]() |