ConvertTimezone
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.
Usage
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.
Example
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.