select extract(year from cast('now' as date)) from rdb$database

----- Original Message -----
From: "juniormello" <eduardo.mello@...>
To: <firebird-support@yahoogroups.com>
Sent: Thursday, June 16, 2005 12:20 PM
Subject: [firebird-support] extract year from a date


> Hello everyone,
> I need to extract the year (in the YY format) from the current date.
> Does anyone knows how to do it?
>
> Tkz for the help,
>
> Eduardo
>
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net 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
>
>
>
>
>
>