TO_CHAR(date, 'ww') should give you the week of the year, oh but thinking about that you will need to also check that the years are the same