| Subject | RE: [firebird-support] Equivalent to Oracle's Select .... from dual |
|---|---|
| Author | Thomas Steinmaurer |
| Post date | 2004-06-04T17:58:37Z |
> Dear Friends,Use RDB$DATABASE for that.
>
> In Oracle we used to do
>
> Select <expression>
> from Dual
>
> e.g. Select F_dayofmonth('01-apr-2004')||' '||F_Dayofweek('01-apr-2004')
> from dual
>
> result will be "01 Mon"
>
> Is there any equivalent to this in Firebird SQL ?
Select
F_dayofmonth('01-apr-2004')||' '||F_Dayofweek('01-apr-2004')
from
rdb$database;
HTH,
Thomas Steinmaurer
LogManager Serie - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database and MS SQL Server
Upscene Productions
http://www.upscene.com