I have a query which does a count of widgets produced a week over a period of time.

However my 1st week of the year starts 1 Jan 2005 and end 2 Jan 2005.

The 2nd week would be 03 Jan 2005 and end 09 Jan 2005.



I know oracle has rules in terms of how it handles the first week number using IW and WW. However I am at pains create a script or mask that would follow the rule i have described above.

Advice appreciated.