March 4th, 2004, 01:05 PM
Does FB have something like Oracle's Dual table?
I'm kinda new to FireBird (and Oracle too, but that's another story...), so this question may sound stupid, but here it goes anyway:
Is there a way to do something like "SELECT current_timestamp FROM [dummy table name] (like in Oracle) or without the FROM clause at all, (like in MSSql)?
Thanks in advance
March 4th, 2004, 01:19 PM
use the FB style:
Originally Posted by lronqui
"rdb$database" or any table with only one row (for an singleton result).
SELECT current_timestamp FROM rdb$database
Romania it's a beautiful country ... too bad that it's populated with ... peoples!
March 4th, 2004, 01:30 PM
Wow, that was fast!
Originally Posted by goreXP