> how can I get system date complete (yyyy-mm-dd hh:mm:ss) in Firebird use
> SQL? i have used CAST ('TODAY' AS TIMESTAMP), but the value of time is
> zero..
> example : 2002-05-31 00:00:00

But you got the _date_ complete :-)
'TODAY' has always zero time portion, you probably want to use 'NOW' instead,
or better yet CURRENT_TIMESTAMP (which is of type TIMESTAMP, so you do not need
to cast it).

Ivan
http://www.volny.cz/iprenosil/interbase