Subject Re: [firebird-support] Strange timestamp math w/ FB 2.5
Author Doug Chamberlin
On 10/20/2010 1:21 PM, Ismael L. Donis GarcĂ­a wrote:
> Try substituting CAST('NOW' AS TIMESTAMP) for CURRENT_TIMESTAMP

I think he had it correct the first time. CURRENT_TIMESTAMP will return
the same value each time it is invoked within the stored procedure
whereas NOW will obtain a new value each time.

--
Cheers! Doug C.
--
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?
A: Top-posting.
Q: What is the most annoying thing in e-mail?