ronaldorezende wrote:

> and 'YEAR', 'MONTH', 'DAY', 'NOW' ?
> How can I use all of this in select ?

select extract(year from timestamp) from rdb$database;
etc.

'NOW' is current_timestamp:

select current_timestamp from rdb$database;

--
Milan Babuskov
http://fbexport.sourceforge.net