Subject Re: [ib-support] no year/month/date-function in firebird
Author Ann W. Harrison
At 03:14 PM 11/11/2002 +0100, Karl Steinam wrote:
> > >
> > > Select * from employee where month(hire_date) = 6;

Another syntax that works is

select * from employee where hire_date containing 'JUN';


Regards,

Ann
www.ibphoenix.com
We have answers.