MySQL CONVERT_TZ Function

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