Re: now() gives same time within the session

From: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: now() gives same time within the session
Date: 2010-07-18 08:54:05
Message-ID: 4C42C12D.4090403@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 12/07/10 14:15, A. Kretschmer wrote:
> Use timeofday() instead, now() returns the transaction starting time.

timeofday() is a legacy function kept only for backwards-compatibility.
It returns a string, which is quite awkward. Use clock_timestamp() instead.

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Rajesh Kumar Mallah 2010-07-18 16:18:05 Re: Pooling in Core WAS: Need help in performance tuning.
Previous Message Srikanth 2010-07-17 08:50:26 What is the best way to optimize the query.