Time Zone Date Functions

When you enable the time zone feature, you can use the fields of the DateTime and DateOnly type to access date information in the specified time zone. For example, if a user in New York runs a SAQL query, they see date information displayed in Eastern Standard time.

In SAQL, the DateOnly type displays the date with an empty timestamp, for example, “2014-12-31 00:00:00.” The inclusion of the timestamp is a limitation of the beta release.

Note

Use Time Zone-Enabled Dates in SAQL Projections

You can project an exact date such as 2017-3-31 23:59:59 or part of a date such as year, month, or day.
Access Date Functions with Time Zone Enabled

Use these functions to get the day, week, year, and other parts of DateTime or DateOnly fields. The return values are numbers.
Group By Date

You can group the result of your SAQL query by DateTime and DateOnly fields.
Order By Date

You can order the result of your SAQL queries by DateTime or DateOnly.
Filter By Date

You can filter results by DateTime and DateOnly fields. Filters can include exact dates, specific date ranges, or relative date ranges.
Calculate the Time Between Two Dates

Use date_diff() and daysBetween() to calculate the time between two dates.
Convert Dates to and from Strings

You can convert dates to strings.
Handle Null Dates

Use is not null to filter out null dates.
Determine the Day in the Week, Month, Quarter, or Year

These functions return the day of the week, month, quarter, or year, the date of the last day of the week, month, quarter, or year, and the number of days in the quarter or year.