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
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? |