Month
Summary
The Month function takes a date or date_time value and returns an integer value ranging from 1-12. The return values correspond to the calendar year where 1 and 12 represent January and December, respectively.
Syntax
Month(<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 Month(ToDate(‘2042-04-01’))
select date1, Month(date1), Month(date_time1), Month(offset_date_time1), Month(zoned_date_time1) from AllTypes();
