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.

Syntax

CONVERT_TZ (dateobj, oldtz, newtz)

Arguments

date_obj: A valid DATE, DATETIME, or parseable date string.
old_tz and new_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 SingleStore 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

SQL

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                           |
+-----------------------------------------------+

SQL

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