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

WEEK ( time_expression ) 

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:

SELECT *
    FROM orders
    WHERE WEEK (order_date) = 5 ; 

NOTES

COMPATIBILITY

ODBC Compatible


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095