weekOfYear
Syntax
weekOfYear(X)
Arguments
X is a scalar/vector of type DATE, DATETIME, TIMESTAMP or NANOTIMESTAMP.
Details
For each element in X, return a number indicating which week of the year it falls in. Each week starts on Monday.
Examples
weekOfYear(2012.01.07);
// output
1
weekOfYear(2013.01.07);
// output
2
weekOfYear(2012.07.02);
// output
27
weekOfYear([2012.06.12T12:30:00,2012.10.28T12:35:00,2013.01.06T12:36:47,2013.04.06T08:02:14]);
// output
[24,43,1,14]Related function: dayOfYear, dayOfMonth, quarterOfYear, monthOfYear, hourOfDay, minuteOfHour, secondOfMinute, millisecond, microsecond, nanosecond