Thanks to Patrick and Richard for pointing out timeofday(); I was
imagining that I'd have to do some server-side-code magic to get that.
But I'm still hoping that someone will have a better solution - using
this I still need a near-global lock between setting the timestamps and
committing the t
Phil Endecott wrote:
Dear All,
Within a transaction, now() and current_timestamp are constant and give
the time that the transaction started. This is normally what you want.
But I have a case where I actually need the time that the transaction
is committed, or something similar. Is there a wa
Hi,
I think that timeofday() should solve your issue.
Just take care that this function returns text instead of timestamp... You
will have to cast it.
Patrick
> --
-
> Patrick Fiche
> email : [EMAIL PROTECTED
