At 10:53 PM 24/04/2006, you wrote:

>Helen,
>
> > EXTRACT (MONTH FROM mydate)
> > or DAY, YEAR..
>
>In what version of Firebird (or InterBase?) has theen been introduced?

IB 6.0. So Firebird has always had it. The parts you can extract are
YEAR | YEARDAY| MONTH | DAY | WEEKDAY (from a DATE type)
and HOUR | MINUTE | SECOND (from a TIME type). You can extract any
of them from a TIMESTAMP type.

./heLen