> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://help.sigmacomputing.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://help.sigmacomputing.com/_mcp/server.

# ConvertTimezone

> Use the Sigma ConvertTimezone function to convert datetime values to the specified time zone.

The **ConvertTimezone** function converts datetime values to the specified time zone.

## Syntax

```
ConvertTimezone(date, timezone, [from_timezone])
```

Function arguments:

|                    |                                                                                                                                                                                                                  |
| :----------------- | :--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **date**           | (required) The datetime value to convert.                                                                                                                                                                        |
| **timezone**       | (required) The TZ identifier of the IANA time zone *to* which the datetime value is converted. See [List of TZ database time zones](https://en.wikipedia.org/wiki/List_of_tz_database_time_zones) for reference. |
| **from\_timezone** | <p>(optional) The TZ identifier of the IANA time zone *from* which the datetime value is converted.</p><p>Defaults to the organization account time zone when the argument is unspecified.</p>                   |

## Notes

* The **timezone** and **from\_timezone** arguments support a column of IANA time zones as text to perform dynamic time zone conversion.
* **ConvertTimezone** shifts the input datetime by the offset difference between the `from_timezone` and `timezone`. Because all date values in Sigma are represented in the organization account time zone, the result is not necessarily being displayed in the timezone specified in the `timezone` argument.

## Examples

```
ConvertTimezone([Date], "America/Los_Angeles")
```

Interprets values in the *Date* column as datetime values in the organization [account time zone](/docs/account-time-zone), then converts them to the equivalent datetime values in America/Los\_Angeles (Pacific) time.

```
ConvertTimezone(Date("2014-07-18 10:58:00"), "America/Los_Angeles", "America/New_York")
```

Interprets `2014-07-18 10:58:00` in America/New\_York (Eastern) time and converts it to `2014-07-18 07:58:00`, the corresponding time in the America/Los\_Angeles (Pacific) time zone.

```
ConvertTimezone(Date([Date]), [Time zone], [From time zone])
```

Converts the text "2025-01-01 00:00:00" in the *\[Date]* column to a date, then converts it from the time zone specified in *\[From time zone]* to the time zone specified in *\[Time zone]*.

![A table with four columns - date, time zone, from time zone, and conversion shows the date 2025-01-01 converted dynamically from and to several different time zones.](https://fdr-prod-docs-files-public.s3.us-east-1.amazonaws.com/sigma.docs.buildwithfern.com/acb26f43869f5322414f2fa8ed8b3ac8e4eb1c2826861bbe58363401d59c8b44/assets/docs-images/f0ab09bdb6f22ca6ad3aa62809a17496241cdb0f7ce51d341d4c2c165b36ee22-convert_timezone.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=AKIA6KXJSKKNFOCF7G4B%2F20260727%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20260727T041441Z&X-Amz-Expires=604800&X-Amz-Signature=fc50141b7954c8f725a7646c4592390dc6e0e4dfc1e4f6e9d09c26178263f542&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject)

## Related resources

* [Date](/docs/date)
* [DateParse](/docs/dateparse)
* [DateTime](/docs/datetime)
* <a href="https://quickstarts.sigmacomputing.com/guide/common_date_functions/index.html" target="_blank" rel="noopener noreferrer">
    Quickstart: Common date functions and use cases
  </a>