monthOfYear
Syntax
monthOfYear(X)
Arguments
X is a scalar/vector of type DATE, MONTH, DATETIME, TIMESTAMP or NANOTIMESTAMP.
Details
For each element in X, return a number from 1 to 12 indicating which month of the year it falls in.
Examples
monthOfYear(2012.07.02);
// output
7
monthOfYear([2012.06.12T12:30:00,2012.10.28T12:35:00,2013.01.06T12:36:47,2013.04.06T08:02:14]);
// output
[6,10,1,4]
Related functions: dayOfYear, dayOfMonth, quarterOfYear, weekOfYear, hourOfDay, minuteOfHour, secondOfMinute, millisecond, microsecond, nanosecond