dayOfYear

Syntax

dayOfYear(X)

Details

Return the day of the year for each element in X.

Parameters

X is a scalar/vector of type DATE, DATETIME, TIMESTAMP or NANOTIMESTAMP.

Returns

An integer.

Examples

dayOfYear(2011.01.01);
// output: 1

dayOfYear([2011.12.31,2012.12.31]);
// output: [365,366]

dayOfYear([2012.06.12T12:30:00,2012.07.12T12:35:00]);
// output: [164,194]

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