well, at the same time the 30st of december definitely belongs to the
last week of 2008!?
one can't use this function without a separate check..
greetings.
--- In firebird-support@yahoogroups.com, Hannes Streicher
<hstreicher@...> wrote:

>
> Guten Tag crizoo4712,
>
> am Mittwoch, 23. April 2008 um 11:36 schrieben Sie:
>
>
> > select extract(week from date '30.12.2008') from rdb$database
> > returns the value 1.
> > It should return 53...
>
> no the first week in a year is the week with at least 4 days
> and this is the case for 30 dez 08
> it is the first week of 2009
>
>
> > ------------------------------------
>
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> > Visit http://www.firebirdsql.org and click the Resources item
> > on the main (top) menu. Try Knowledgebase and FAQ links !
>
> > Also search the knowledgebases at http://www.ibphoenix.com
>
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> > Yahoo! Groups Links
>
>
>
>
> --
> Mit freundlichen Grüssen
> Hannes Streicher mailto:HStreicher@...
>