MySQL CONVERT_TZ function is one of the MySQL Date Function, which converts the given DateTime from One time zone to another time zone.
Let us see how to use this MySQL CONVERT_TZ function to change the timezones of a date expression with an example.
MySQL CONVERT_TZ Syntax
The basic syntax of the CONVERT_TZ() Function in MySQL is as shown below:
CONVERT_TZ(Date, from_timezone, to_timezone);
MySQL CONVERT_TZ function Example
In this example, First, we used three statements to convert the given date into different timezones.
SELECT CONVERT_TZ('2019-02-28 23:59:59', '+00:00', '+05:50');
SELECT CONVERT_TZ('2019-02-28 23:59:59', '+00:00', '-05:50');
SELECT CONVERT_TZ('2019-02-28 23:59:59', '+00:00', '+10:30');OUTPUT
