CONVERT_TZ()

Overview

Converts the given datetime value from the first time zone to the second time zone.

See also: Functions in 10.6 ES, in 10.5 ES, and in 10.4 ES

EXAMPLES

SELECT CONVERT_TZ('2020-01-01 12:00:00','+00:00','+5:00');
+----------------------------------------------------+
| CONVERT_TZ('2020-01-01 12:00:00','+00:00','+5:00') |
+----------------------------------------------------+
| 2020-01-01 17:00:00                                |
+----------------------------------------------------+

CHANGE HISTORY

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

EXTERNAL REFERENCES