Hi,

At September 27, 2004, 16:39, trac_t2000 wrote:

>> What are you using to get the timestamp? CURRENT_TIMESTAMP or 'NOW'?
>>

> I am using CURRENT_TIMESTAMP.

CURRENT_TIMESTAMP is a context variable, and it will return the
timestamp in the context of the transaction. Essentially, it will
return a consistent timestamp for the whole duration of the
transaction. And, not the exact timestamp when you reference it.

If I remember correctly, 'NOW' should return the extact timestamp no
matter when it is referenced during the transaction.
Here's an example on how to use it:
SP_VAR = CAST('NOW' AS TIMESTAMP)

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)