Subject | Re: [firebird-support] Re: TIMESTAMP arithmatic niggle |
---|---|
Author | Milan Babuskov |
Post date | 2003-12-10T15:09:30Z |
Lester Caine wrote:
CURRENT_TIMESTAMP + cast(1 as double precision) / cast(1440 as double
precision)
--
Milan Babuskov
http://fbexport.sourceforge.net
>>CURRENT_TIMESTAMP + (1.000 / 1440.000)Have your tried to simply cast everything to double precision?
>
> I bit cumbersome but you are right it does work :)
> Can we get this to work any other way?
CURRENT_TIMESTAMP + cast(1 as double precision) / cast(1440 as double
precision)
--
Milan Babuskov
http://fbexport.sourceforge.net