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 way to get it? Here is
> the problem:
You want timeofday() - see the "date/time functions" section of the
manuals. Note that it returns text not timestamptz.
--
Richard Huxton
Archonet Ltd