Roman Bobnar wrote:

> "select cast('now' as date) from dummy"
> returns
> "19-MAR-2003"
>
> I know this statement works in Interbase, not sure if it works in Firebird.

It works if you have a table with one row, called DUMMY, in your database.

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