Subject | Re: [firebird-support] Strange timestamp math w/ FB 2.5 |
---|---|
Author | Doug Chamberlin |
Post date | 2010-10-20T17:53:10Z |
On 10/20/2010 1:21 PM, Ismael L. Donis GarcĂa wrote:
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?
> Try substituting CAST('NOW' AS TIMESTAMP) for CURRENT_TIMESTAMPI 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?