MySQL CONVERT_TZ function is on of the Date Function, which converts the given DateTime from One time zone to another time zone.
In this article, we will show you, 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
Thank You for Visiting Our Blog
