dayOfWeek
Syntax
dayOfWeek(X)
Arguments
X is a scalar/vector of type DATE, DATETIME, DATEHOUR, TIMESTAMP or NANOTIMESTAMP.
Details
Return which day of the week is X.
Return value: an integer from 0 to 6, where 0 means Monday, .., 6 means Sunday.
Examples
dayOfWeek(2012.12.05);
// output
2
dayOfWeek 2013.05.23T12:00:00;
// output
3
dayOfWeek(2014.01.11T23:04:28.113);
// output
5
dayOfWeek(2012.12.05 2012.12.06 2013.01.05);
// output
[2,3,4]