The WEEKOFYEAR() function returns the calendar week of "Date" in the range 1 to 53.
The "Date" argument must be of type DATE or DATETIME.
If the value for "Date" is invalid or NULL, the WEEKOFYEAR() function returns NULL.
The WEEKOFYEAR() function returns the same value as WEEK("Date", 3) . |