|Subject||RE: [ib-support] no year/month/date-function in firebird|
> Hello All,Have a look on the EXTRACT keyword.
> i tried to make a sql-statement like that:
> Select * from employee where month(hire_date) = 6;
> As result i was told the the token month didn't exist.
> Looking in the firebird doks i didn't found an example for
> So are these functions not existing in firebird ??
SELECT * FROM EMPLOYEE WHERE EXTRACT(MONTH FROM HIRE_DATE) = 6;
IB LogManager 2.1 - The Logging/Auditing Tool for InterBase and Firebird