Subject | Re: [firebird-support] Re: TIMESTAMP arithmatic niggle |
---|---|
Author | Lester Caine |
Post date | 2003-12-10T09:02:28Z |
>>DELETE = CURRENT_TIMESTAMP + (30.0 / 1440.0) gives +30 minutesIt may be - I had not looked closer then 10 min steps ;)
>>
>>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
> 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