|
|
|
|
|
|
|
|
|
|
version 11
WEEK (arithmetic_expression)
Description
The WEEK function returns the week of the year (ranging from 1 to 54) of the date passed in the arithmetic_expression. The week begins on Sunday and January 1st is always in the first week.
Example
This example returns a number representing the week of the year for each date of birth passed:
SELECT WEEK(Date_of_birth);
See Also
|
|
|
|
|
|
|
|
|
|