WEEK

The WEEK function returns an integer value representing the week of the year from a date expression.

Syntax

WEEK( dateExpr );

dateExpr

The date-time expression from which you wish to extract information.

Results

The returned week number is in the range 1 to 53.

Examples

splice> SELECT BirthDate, Week(BirthDate) "BirthWeek"
   FROM Players
   WHERE ID < 15;
BIRTHDATE |BIRTHWEEK
----------------------
1987-03-27|13
1988-04-20|16
1990-10-30|44
1987-01-21|4
1991-01-15|3
1982-01-05|1
1981-07-02|27
1983-04-13|15
1983-12-24|51
1983-11-06|44
1990-06-16|24
1977-08-30|35
1990-03-22|12
1982-10-12|41

14 rows selected

See Also