>>>>> On Mon, 3 Jun 2002 06:52:07 +0800, Rotandiko Sastroprawiro <rsastroprawiro@...> said:

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

Try CAST('NOW' AS TIMESTAMP).

hth, ciao, lele.
--
nickname: Lele Gaifax | Quando vivro' di quello che ho pensato ieri
real: Emanuele Gaifas | comincero' ad aver paura di chi mi copia.
email: lele@... | -- Fortunato Depero, 1929.