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