Outdated Version
You are viewing an older version of this section. View current production version.
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_tz
andnew_tz
: Any valid timezone identifier.
Info
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 derive from the memsql_timezones.txt
file in the share
directory of your MemSQL installation directory. The timezone names do not derive 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
memsql> 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 |
+-----------------------------------------------+
memsql> 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 |
+-------------------------------------------------+