# 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.

> **❗ 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>.

## 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');

```

```output

+-----------------------------------------------+
| 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');

```

```output

+-------------------------------------------------+
| CONVERT_TZ('2014-04-18 12:00:00','GMT','-3:14') |
+-------------------------------------------------+
| 2014-04-18 08:46:00                             |
+-------------------------------------------------+
```

***

Modified at: May 31, 2023

Source: [/cloud/reference/sql-reference/date-and-time-functions/convert-tz/](https://docs.singlestore.com/cloud/reference/sql-reference/date-and-time-functions/convert-tz/)

(An index of the documentation is available at /llms.txt)