Tuesday, May 11, 2010

Oracle's select from dual for Firebird

This will definitely come in handy:
For firebird there is a system defined table that contains one and only one row RDB$DATABASE.

so you can get the current time e.g. from the following query:
select current_time from RDB$DATABASE;

Enjoy!