fbpx
Select Page

Converts a UTC date to a different time zone.

Usage

ConvertTimezone(<date>, <timezone>)

date (required): The UTC date to convert.
timezone (required): The name of the IANA timezone to convert the input date into.

Examples

ConvertTimezone([Date], “America/Los_Angeles”)
  • Converts all of the dates in the [Date] column to Pacific Time.
ConvertTimezone(Date(“2014-07-18 10:58:00”), “America/New_York”)
  • 2014-07-18 06:58:00

More About Date Functions

Date functions are useful for analyzing date input and extracting individual time components, like year or minute, from date objects.

We are rewriting the rules of analytics. Sigma empowers domain experts to join the data conversation, answer the toughest questions, and drive insights.