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);
7

$ monthOfYear([2012.06.12T12:30:00,2012.10.28T12:35:00,2013.01.06T12:36:47,2013.04.06T08:02:14]);
[6,10,1,4]

Related functions: dayOfYear, dayOfMonth, quarterOfYear, weekOfYear, hourOfDay, minuteOfHour, secondOfMinute, millisecond, microsecond, nanosecond