Subject From the Secret Files
Author Helen Borrie
Try this:

select timestamp 'now' from rdb$database

Also keywords time and date, used with the appropriate date literals, e.g.

update blah
set date = date '07.02.2005'

Just revealed in passing by D. Yemanov - a syntax we inherited in the IB 6
code!

cheers
./heLen