Thread: Current time inside Transactions

Hi,

Is there is a way to get the real curren_time inside a transaction (not
the time when the transaction stated)

Daniel

On Wednesday 01 October 2003 12:51, Daniel Schuchardt wrote:
> Hi,
>
> Is there is a way to get the real curren_time inside a transaction (not
> the time when the transaction stated)

SELECT timeofday();

Note that this returns a text-type (for historical reasons apparently)

--
  Richard Huxton
  Archonet Ltd

On Wed, 1 Oct 2003, Daniel Schuchardt wrote:

> Hi,
>
> Is there is a way to get the real curren_time inside a transaction (not
> the time when the transaction stated)

begin;
select timeofday();
select timeofday();
commit;