Date Functions

yyyymm

Returns the year and month of the timestamp field in the format yyyymm where yyyy is a four digit year and mm is a 2 digit month (01-12).

Examples:

yyyymm('2022-03-15T00:29:17Z') // returns 202203

yyyyq

Returns the year and quarter of the timestamp field in the format yyyyq where yyyy is a four digit year and q is a 1 digit quarter (1-4).

Examples:

yyyyq('2022-03-15T00:29:17Z') // returns 20221

year

Returns the year of the timestamp

Examples:

year('2022-03-15T00:29:17Z') // returns 2022

month

Returns the month of the timestamp

Examples:

year('2022-03-15T00:29:17Z') // returns 3

quarter

Returns the quarter of the timestamp

Examples:

quarter('2022-03-15T00:29:17Z') // returns 1