DayOfYear
Summary
The DayOfYear function returns the numeric day of the year for the specified date.
Syntax
DayOfYear(<date|date_time|instant|offset_date_time|zoned_date_time>) |
Return Type
Integer
Details
Returned values range from 1-366.
Examples
eval DayOfYear(ToDate(‘2042-04-01’));
select date1, DayOfYear(date1), DayOfYear(date_time1), DayOfYear(offset_date_time1), DayOfYear(zoned_date_time1) from AllTypes();
