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

-Roman

-----Original Message-----
From: Aage Johansen [mailto:aagjohan@...]
Sent: Wednesday, March 19, 2003 3:09 PM
To: ib-support@yahoogroups.com
Subject: [ib-support] Re: date of server


Woody wrote:
------------------------

>> SELECT CURRENT_DATE FROM RDB$DATABASE

...
Although this is the solution most of us probably use, on the Borland side,
they are advising creating your own table with one record to do this with.
The reasoning is that the RDB$DATABASE table may not exist in future
versions or may be changed to hold more than one record. Relying on it in
it's current state may be detrimental to using newer versions of Interbase.
I don't know if there is any speculation about this on the Firebird side,
though.
------------------------


How many applications do they want to break?


Regards,
Aage J.



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/