> Hello All,
>
> 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
> year/month/day-selects.
>
> So are these functions not existing in firebird ??

Have a look on the EXTRACT keyword.

For example:

SELECT * FROM EMPLOYEE WHERE EXTRACT(MONTH FROM HIRE_DATE) = 6;

Regards,
Thomas Steinmaurer
IB LogManager 2.1 - The Logging/Auditing Tool for InterBase and Firebird
http://www.iblogmanager.com