Subject Re: [firebird-support] Re: Select extract(week from date '30.12.2008') from rdb$database returns 1 !?!
Author Helen Borrie
At 07:07 PM 29/04/2008, you wrote:
>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...

A year has only 52 weeks. :-)

./heLen