CONVERT_ TZ
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
On this page
Converts a given datetime object from one timezone to another.
Syntax
CONVERT_TZ (dateobj, oldtz, newtz)
Arguments
-
date_
: A validobj DATE
,DATETIME
, or parseable date string. -
old_
andtz new_
: Any valid timezone identifier.tz
Important
Timezone identifiers may be explicit intervals or named zones.+10:00
or -3:30
and are counted from UTC.America/Mazatlan
or EST
.
The list of supported timezone names is derived from https://www.
A copy of the timezones list is included in a text file -- memsql_
-- in the share
directory of your SingleStore installation directory.
Return Type
A DATE
or DATETIME
object.date_
, old_
, or new_
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 |
+-------------------------------------------------+
Last modified: May 31, 2023