Subject Re: [Firebird-Architect] Extract / Cast Datetime
Author Christian Danner
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.

Ciao

Christian