Re: Current time inside Transactions

From: Richard Huxton <dev(at)archonet(dot)com>
To: "Daniel Schuchardt" <daniel_schuchardt(at)web(dot)de>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Current time inside Transactions
Date: 2003-10-01 12:36:11
Message-ID: 200310011336.11011.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marc G. Fournier 2003-10-01 12:44:21 Re: Hesitate to write this: can't get at postgres.org
Previous Message Stefan Leitich 2003-10-01 12:01:16 Re: adressing column