Analytics SAQL Developer Guide

Overview
Quick Start
Examples
SAQL Reference
SAQL Basic Elements
SAQL Operators
SAQL Statements
SAQL Functions
Aggregate Functions
Date Functions
daysBetween()
date_diff()
now()
date()
toDate()
date_to_epoch()
date_to_string()
toString()
Time-Based Filtering
Day in the Week, Month, Quarter, or Year
First Day in the Week, Month, Quarter, or Year
Last Day in the Week, Month, Quarter, or Year
Number of Days in the Month, Quarter, or Year
Date Formats
Time Zone Date Functions
Work with Custom Fiscal Year Data
String Functions
Math Functions
Windowing Functions
coalesce
Query Performance
PDF

Date Formats

For Date fields, specify the format of the date by using one of the following supported formats. Dates must match the format exactly and can't have any extra text.

The date formats listed here are the two-digit versions for date fields that use leading zeros; for example, 03/06/14 09:01:06 AM. If a date field doesn't have leading zeros, use the one-digit version of the format. For example, use the format M/d/yy h:m:s a for date values such as 3/6/14 9:1:26 AM. If you use a two-digit format for a field, rows containing values with one-digit date parts will fail.

The timestamp part of each date format is optional.

The Quarter date format isn’t supported.

Note

Format Sample Value
yyyy-MM-dd'T'HH:mm:ss.SSS'Z' 2014-04-29T16:53:34.000Z
yy-MM-dd'T'HH:mm:ss.SSS'Z' 14-04-29T16:53:34.000Z
yyyy-MM-dd'T'HH:mm:ss'Z' 2014-04-29T16:53:34Z
yy-MM-dd'T'HH:mm:ss'Z' 14-04-29T16:53:34Z
yyyy-MM-dd HH:mm:ss 2014-06-03 11:31:45
yy-MM-dd HH:mm:ss 14-06-03 11:31:45
dd.MM.yyyy HH:mm:ss 03.06.2014 11:31:45
dd.MM.yy HH:mm:ss 03.06.14 11:31:45
dd/MM/yyyy HH:mm:ss 03/06/2014 11:31:45
dd/MM/yy HH:mm:ss 03/06/14 11:31:45
dd/MM/yyyy hh:mm:ss a 03/06/2014 11:31:45 AM
dd/MM/yy hh:mm:ss a 03/06/14 11:31:45 AM
dd-MM-yyyy HH:mm:ss 03-06-2014 11:31:45
dd-MM-yy HH:mm:ss 03-06-14 11:31:45
dd-MM-yyyy hh:mm:ss a 03-06-2014 11:31:45 AM
dd-MM-yy hh:mm:ss a 03-06-14 11:31:45 AM
MM/dd/yyyy hh:mm:ss a 06/03/2014 11:31:45 AM
MM/dd/yy hh:mm:ss a 06/03/14 11:31:45 AM
MM-dd-yyyy hh:mm:ss a 06-03-2014 11:31:45 AM
MM-dd-yy hh:mm:ss a 06-03-14 11:31:45 AM
HH:mm:ss dd/MM/yyyy 11:31:45 03/06/2014
HH:mm:ss dd/MM/yy 11:31:45 03/06/14

These formats use the following symbols:

Symbol Meaning
yyyy or yy Four-digit year (yyyy) or two-digit year (yy)
MM Two-digit month (01–12)
M One-digit month when month less than 10 (1–12)
dd Two-digit day (01–31)
d One-digit day when day less than 10 (1–31)
'T' A separator that indicates that time of day follows
HH Two-digit hour (00–23)
H One-digit hour when hour less than 10 (0–23)
mm Two-digit minute (00–59)
m One-digit minute when minute less than 10 (0–59)
ss Two-digit second (00–59)
s One-digit second when second less than 10 (0–59)
SSS Optional three-digit milliseconds (000–999)
'Z' The reference UTC time zone