Re: Timestamps Look Incorrect?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Lane Van Ingen" <lvaningen(at)esncc(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Timestamps Look Incorrect?
Date: 2005-09-28 21:30:45
Message-ID: 5058.1127943045@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"Lane Van Ingen" <lvaningen(at)esncc(dot)com> writes:
> I have used localtimestamp, now(), and
> to_char(localtimestamp,'HH24:MI:SS.US') to display current time at different
> points in the stored procedure; even though I have requested microseconds,
> all of the results being returned are all the same: the time that is shown
> on the very first RAISE NOTICE is exactly the same as the last one, even
> though I stored the time into different variables.

That's what it's supposed to do. Please read the documentation:
http://www.postgresql.org/docs/8.0/static/functions-datetime.html#FUNCTIONS-DATETIME-CURRENT
You need to use timeofday() if you want to measure intra-transaction
intervals.

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Glaesemann 2005-09-28 21:33:10 Re: Timestamps Look Incorrect?
Previous Message Lane Van Ingen 2005-09-28 20:12:44 Timestamps Look Incorrect?