Examples of SELECT WEEK usage:
select week(date); select week(current_date); select week(date '1900-01-01'); select week(date '1899-12-31'); select week(date '1700-05-31'); select week(date - interval '300' year); select week(date - interval '6' month); select week(date - interval '150' day);