> -----Original Message-----
> From: Firebird-Architect@yahoogroups.com
> [mailto:Firebird-Architect@yahoogroups.com]On Behalf Of Daniel Rail
>
> > Then you would also have to return the corresponding year. IMHO it's
> > sufficient to cover such a higher level task by a sp (see
> > http://www.danner-net.de/fbd_sql_timestamp_to_week_of_year.htm.
>
> Why the year? Week number one is the week where January 1 is on. So
> if December 31 is on the same week as January 1, then the week number
> for December 31 is one.

Isn't that the first week is the one that has a Thursday? Anything that
doesn't meet that property is the last week of the previous year.

C.