Neoview SQL Reference Manual (R2.3)

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