Subject Re: [firebird-support] Re: TIMESTAMP arithmatic niggle
Author Milan Babuskov
Lester Caine wrote:
>>CURRENT_TIMESTAMP + (1.000 / 1440.000)
>
> I bit cumbersome but you are right it does work :)
> Can we get this to work any other way?

Have your tried to simply cast everything to double precision?

CURRENT_TIMESTAMP + cast(1 as double precision) / cast(1440 as double
precision)


--
Milan Babuskov
http://fbexport.sourceforge.net