CONVERT_TZ()
This page is part of MariaDB's Documentation.
The parent of this page is: Functions for MariaDB Enterprise Server
Topics on this page:
Overview
Converts the given datetime value from the first time zone to the second time zone.
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
EXTERNAL REFERENCES
Additional information on this topic may be found in the MariaDB Public Knowledge Base.