CONVERT_TZ
Converts a given datetime object from one timezone to another.
Syntax
CONVERT_TZ (dateobj, oldtz, newtz)
Arguments
date_obj: A validDATE,DATETIME, or parseable date string.old_tzandnew_tz: Any valid timezone identifier.
Important
Timezone identifiers may be explicit intervals or named zones. Explicit intervals are in the form +10:00 or -3:30 and are counted from UTC. Named timezones are in the form America/Mazatlan or EST.
The list of supported timezone names is derived from https://www.iana.org/time-zones.
A copy of the timezones list is included in a text file -- memsql_timezones.txt -- in the share directory of your SingleStoreDB installation directory. The timezone names are not derived from any settings on the host operating system.
Return Type
A DATE or DATETIME object. If date_obj, old_tz, or new_tz is not valid, returns NULL.
Examples
SELECT CONVERT_TZ('2014-04-18 12:00:00','GMT','EST');
****
+-----------------------------------------------+
| CONVERT_TZ('2014-04-18 12:00:00','GMT','EST') |
+-----------------------------------------------+
| 2014-04-18 07:00:00 |
+-----------------------------------------------+
SELECT CONVERT_TZ('2014-04-18 12:00:00','GMT','-3:14');
****
+-------------------------------------------------+
| CONVERT_TZ('2014-04-18 12:00:00','GMT','-3:14') |
+-------------------------------------------------+
| 2014-04-18 08:46:00 |
+-------------------------------------------------+