"Campano, Troy" <Troy(dot)Campano(at)LibertyMutual(dot)com> writes:
> However the data says that April 28th 2004 was in week 4 of April and
> that April 29th 2004 was in week 5 of april.
> This is incorrect.
This *is* correct according to our published specification for the W
format code:
W week of month (1-5) (The first week starts on the first day of the month.)
Since you haven't defined what behavior you want, it's hard to suggest
alternatives, but have you looked at the WW and IW format codes?
regards, tom lane