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]