Thanks..very much..


-----Original Message-----
From: lele@... [mailto:lele@...]
Sent: Monday, June 03, 2002 6:53 AM
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] get system date complete

>>>>> 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.



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/