WEEK

Returns the week of the year as a short integer value in the range of 1-53.

Syntax

WEEK ( time_expression )

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 valid date_literal formats where the day specification (DD) precedes the month specification (MM).

The result is of type SHORT.

If the argument expression evaluates to NULL, the result is NULL.

Example

The query returns all columns from rows in the orders table where the order_date is in the fifth week of the year. This example illustrates the WEEK function:

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

Compatibility

ODBC compatible