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?