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:-

Output:-