Progress
SQL-92
Guide and Reference
WEEK Function
Returns the week of the year as a short integer value in the range of 1-53.
SYNTAX
EXAMPLE
The example illustrates the WEEK function. The query returns all columns from rows in the orders table where the order_date is in the fifth week of the year:
NOTES
- The argument to the function must be of type DATE.
- If
date_expression
is supplied as a date literal, it can be any of the validdate_literal
formats where the day specification (DD) precedes the month specification (MM). See the syntax for adate_literal
in the “Date Literals” section.- The result is of type SHORT.
- If the argument expression evaluates to null, the result is null.
COMPATIBILITY
ODBC Compatible
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |