Hi Thomas

Thank you very much. Works exactly as I need.

Regards

Daniel

----- Original Message -----
From: Thomas Steinmaurer
To: firebird-support@yahoogroups.com
Sent: Tuesday, November 04, 2003 4:25 PM
Subject: RE: [firebird-support] Current date via database query


> How can I get the current date via a database query?
>
> In a Sybase database it would be >>> select 'today' = getDate() <<< and in a SAP database it would be >>> select {fn
> NOW()} from DumyTable <<<
>
> What is the equivalent in Firebird?

Use the CURRENT_DATE keyword. For example:

SELECT CURRENT_DATE FROM RDB$DATABASE;


HTH,
Thomas


Yahoo! Groups Sponsor
ADVERTISEMENT




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



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]