Analytics SAQL Developer Guide
jSummer '25 preview (API version 64.0)
Spring '25 (API version 63.0)
Winter '25 (API version 62.0)
Summer '24 (API version 61.0)
Spring '24 (API version 60.0)
Winter '24 (API version 59.0)
Summer '23 (API version 58.0)
Spring '23 (API version 57.0)
Winter '23 (API version 56.0)
Summer '22 (API version 55.0)
Spring '22 (API version 54.0)
Winter '22 (API version 53.0)
Summer '21 (API version 52.0)
Spring '21 (API version 51.0)
Winter '21 (API version 50.0)
Summer '20 (API version 49.0)
Spring '20 (API version 48.0)
Winter '20 (API version 47.0)
Summer '19 (API version 46.0)
Spring '19 (API version 45.0)
Winter '19 (API version 44.0)
Summer '18 (API version 43.0)
Spring '18 (API version 42.0)
Winter '18 (API version 41.0)
Summer '17 (API version 40.0)
Spring '17 (API version 39.0)
Winter '17 (API version 38.0)
Summer '16 (API version 37.0)
Spring '16 (API version 36.0)
Winter '16 (API version 35.0)
No Results
Search Tips:
- Please consider misspellings
- Try different search keywords
Use Time Zone-Enabled Dates in SAQL Projections
Access Date Functions with Time Zone Enabled
Group By Date
Order By Date
Filter By Date
date_to_string(DateTime | DateOnly, format)
toDateTime(epoch)
toDateTime(string, format)
toDateOnly(epoch)
toDateOnly(string, format)
Handle Null Dates
Windowing Functions
coalesce
Convert Dates to and from Strings
You can convert dates to strings.
-
date_to_string(DateTime | DateOnly, format)
Converts a date to a string. -
toDateTime(epoch)
Converts an epoch day to a DateTime type. -
toDateTime(string, format)
Converts a date in string format to a DateTime type. “format” specifies the date format and can be any valid date format. -
toDateOnly(epoch)
Converts an epoch to a DateOnly type. -
toDateOnly(string, format)
Converts a date in string format to a DateOnly type. format specifies the date format and can be any valid date format.