""Thomas Steinmaurer"" <ts@...> schrieb im Newsbeitrag
news:IPEMLLMEPELGFDHGBENCEEGCCLAA.ts@......

> > 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.
>

yes thanks, i saw it just a few lines under my question, that somebody else
asked the same question.
Should read the news first in then ask :-)

KS