[firebird-support] Age as a string and it\'s parts as integer

[Köditz, Martin martin.koed...@it-syn.de [firebird-support]]

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