Hi Bhavbhuti,

please have a look at Firebird’s EXTRACT functions.

e.g.

select extract(year from CAST('1990-01-01' as Date)) from RDB$DATABASE;

returns 1990. Hope this helps.

Regards

Martin