hourOfDay

Syntax

hourOfDay(X)

Arguments

X is a scalar/vector of type TIME, MINUTE, SECOND, DATETIME, TIMESTAMP, NANOTIME or NANOTIMESTAMP.

Details

For each element in X, return a number from 0 to 23 indicating which hour of the day it falls in.

Examples

$ hourOfDay(00:46:12);
0

$ hourOfDay([2012.06.12T12:30:00,2012.10.28T17:35:00,2013.01.06T02:36:47,2013.04.06T08:02:14]);
[12,17,2,8]

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