Subject | Re: [firebird-support] Backporting query to Firebird 1.5 |
---|---|
Author | Anderson Farias |
Post date | 2008-10-03T05:27:57Z |
Hi,
select current_timestamp-cast(10.321 as numeric(18,9)) from rdb$database;
runs just fine!
Regards,
Anderson Farias
> SELECT * FROM TABLE WHERE TIMESTAMPFIELD > (CURRENT_TIMESTAMP - CAST(?I've tested against FB 1.5.4 and it works fine
> as DECIMAL(18,9))
> However, if I try to execute this in older system with Firebird 1.5,I can't reproduce the error against fb 1.5.4, ex:
> I get "Unknown data type" error.
select current_timestamp-cast(10.321 as numeric(18,9)) from rdb$database;
runs just fine!
Regards,
Anderson Farias