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

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