Postgres Pro
Downloads
Home   >   mailing lists

Re: Current time inside Transactions - Mailing list pgsql-general

From Richard Huxton
Subject Re: Current time inside Transactions
Date
Msg-id 200310011336.11011.dev@archonet.com
Whole thread Raw
In response to Current time inside Transactions  ("Daniel Schuchardt" <daniel_schuchardt@web.de>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Stefan Leitich
Date:
Subject: Re: adressing column
Next
From: "Marc G. Fournier"
Date:
Subject: Re: Hesitate to write this: can't get at postgres.org