> 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