Hi,

> I would like ask if there is any way in Firebird extract week number
> from
> date (so number between 1 and 52(53?)) ?
> Syntax like
> extract(week from d)

Something like that is not available.

Either use an UDF or have a look here, for a stored procedure
implementation:
http://www.volny.cz/iprenosil/interbase/ip_ib_code_timestamp.htm




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