Subject Re: [firebird-support] Re: TIMESTAMP arithmatic niggle
Author Lester Caine
>>DELETE = CURRENT_TIMESTAMP + (30.0 / 1440.0) gives +30 minutes
>>
>>but
>>DELETE = CURRENT_TIMESTAMP + (1.0 / 1440.0) does not give +1
>>minute
>>
>>I would rather make the number of minutes an offset that the
>>user can change, and do the arithmetic for them, but all
>>attempts at times less then about 20 minutes 'round' to
>>zero. Anybody see where I am going wrong?
>
> Hi Lester!
> If the limit had been 15 minutes rather than 20, that would have been
> where the time passed two decimals. I have not even tried Fb 1.5
> myself yet, but on Fb 1.0.2 I get one minute (or at least 59 second)
> added by using

It may be - I had not looked closer then 10 min steps ;)

> 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?

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services