At 11:13 AM 3/29/2001 -0600, you wrote:
>i'd agree with you.
>but as tom lane mentioned, current_date is today, all day, until
>midnight (local time zone, i presume) whereas current_timestamp
>is less chunky, having finer grains down to one second.
>but even there, the timestamp is apparently (just learned this
>today from other posts on this thread) set for the start of the
>current transaction (or is it session?)...
>timeofday() may be what you're after.
I'm new to stored procedures, triggers and pl/pgsql. The mistakes I'll
likely make will be simple ones and I should have thought of timestamp vs.
date, sorry to ask such foolish questions.
In response to
pgsql-general by date
|Next:||From: Tom Lane||Date: 2001-03-29 17:49:33|
|Subject: Re: tables, where |
|Previous:||From: Larry Rosenman||Date: 2001-03-29 17:41:08|
|Subject: Re: timestamp/function question |