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
Köditz, Martin martin.koed...@it-syn.de [firebird-support] Thu, 07 Jan 2016 02:14:36 -0800
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