Quarter
Summary
The Quarter function takes a date or date_time value and returns an integer value ranging from 1-4. The return values correspond to the calendar year where 1 represents January 1 through March 31.
Syntax
Quarter(<date|date_time|instant|offset_date_time|zoned_date_time>) |
Return Type
Integer
Details
Consider joining to the xactly.xc_period table if your business’ fiscal year differs from the standard calendar year.
Examples
eval Quarter(ToDate(‘2042-04-01’));
select date1, Quarter(date1), Quarter(date_time1), Quarter(offset_date_time1), Quarter(zoned_date_time1) from AllTypes();
