Converts dates from the account timezone into a different timezone.

See Sigma's Common Date Functions and Use Cases lab for more information about date functions, including use cases and exercises.


ConvertTimezone(date, timezone)

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


ConvertTimezone([Date], "America/Los_Angeles")
  • Converts all dates in the [Date] column from the account timezone to Pacific Time.
ConvertTimezone(Date("2014-07-18 10:58:00"), "America/New_York")
  • If the account timezone is America/Los_Angeles, the above will output 2014-07-18 13:58:00.

Was this page helpful?
Yes No