Re: Current time inside Transactions

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Daniel Schuchardt <daniel_schuchardt(at)web(dot)de>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Current time inside Transactions
Date: 2003-10-01 14:15:15
Message-ID: Pine.LNX.4.33.0310010814530.21245-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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;

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vivek Khera 2003-10-01 14:17:38 Re: mod_auth_pgsql 2.0.1 don't close the backend connection
Previous Message Alvaro Herrera 2003-10-01 14:13:45 Re: numeric rounding