TRY
SELECT EXTRACT(YEAR FROM CURRENT_DATE) FROM RDB$DATABASE INTO :MY_YAR

----- Original Message -----
From: "enio_bueno" <enio_bueno@...>
To: <ib-support@yahoogroups.com>
Sent: Wednesday, December 12, 2001 2:34 PM
Subject: [ib-support] how get the current year


> hi to all
> I need get current year
> I do this:
> SELECT 'TODAY' FROM RDB$DATABASE INTO :MY_TODAY
> How can I use extract funtion to extract the year?
> I try
> SELECT EXTRACT(YEAR FROM 'TODAY') FROM RDB$DATABASE INTO :MY_YAR
> but i receive a error message "Specified EXTRACT part does not exist
> in input datatype"
>
> Are thre other way to do this?
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>