Hello Christian,

Sunday, February 12, 2006, 2:54:40 AM, you wrote:

> Hi Ian,

> on Fri, 10 Feb 2006 21:12:21 +0000 (UTC), you wrote:

>>One other thing regarding extract, it would be nice to be able to
>>extract the ISO week number.

> 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.

--
Best regards,
Daniel Rail
Senior Software Developer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)