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

AFAIK, not according the ISO 8601 standard, which the WEEK extraction in
Firebird 2.1 implements, because in ISO 8601, a year has 53 weeks if the
year starts or ends with a Thursday. AFAIK. ;-)


--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com