Joined: 06 Jul 2005
Returns a value in the range 1 to 53 or 54 that represents the week of the year, where a week
begins on a Sunday, or on the first day of the year. Valid input types are a date, a timestamp,
or an equivalent character value. The output is of type integer.
SELECT WEEK(DATE('2000-01-01')) AS W1 ANSWER
,WEEK(DATE('2000-01-02')) AS W2 ==================
,WEEK(DATE('2001-01-02')) AS W3 W1 W2 W3 W4 W5
,WEEK(DATE('2000-12-31')) AS W4 -- -- -- -- --
,WEEK(DATE('2040-12-31')) AS W5 1 2 1 54 53
Figure 318, WEEK function examples
Both the first and last week of the year may be partial weeks. Likewise, from one year to the
next, a particular day will often be in a different week.
Got this from IBM manuals