> try SELECT 'NOW' FROM RDB$DATABASE.

That will deliver a varchar field with "NOW" as its content ;-)

Better would be:
select cast ('NOW' as timestamp) from rdb$database
or
select current_timestamp from rdb$database


Best Regards

Stefan


--
Stefan Heymann
www.destructor.de/firebird