Neoview SQL Reference Manual (R2.2)

DAYOFYEAR Function
The DAYOFYEAR function converts a DATE or TIMESTAMP expression into an INTEGER value
in the range 1 through 366 that represents the corresponding day of the year.
DAYOFYEAR is a Neoview SQL extension.
DAYOFYEAR (datetime-expression)
datetime-expression
is an expression that evaluates to a datetime value of type DATE or TIMESTAMP. See
“Datetime Value Expressions” (page 210).
Example of DAYOFYEAR
Return an integer that represents the day of the year from the START_DATE column in the
PROJECT table:
SELECT start_date, ship_timestamp, DAYOFYEAR(start_date)
FROM persnl.project
WHERE projcode = 1000;
Start/Date Time/Shipped (EXPR)
---------- -------------------------- --------------------
1996-04-10 1996-04-21 08:15:00.000000 101
DAYOFYEAR Function 329