Skip site navigation (1) Skip section navigation (2)

Re: timestamp/function question

From: Soma Interesting <dfunct(at)telus(dot)net>
To: will trillich <will(at)serensoft(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: timestamp/function question
Date: 2001-03-29 17:44:20
Message-ID: 5.0.2.1.0.20010329093945.025f8728@pop.telus.net (view raw or flat)
Thread:
Lists: pgsql-general
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

Responses

pgsql-general by date

Next:From: Tom LaneDate: 2001-03-29 17:49:33
Subject: Re: tables, where
Previous:From: Larry RosenmanDate: 2001-03-29 17:41:08
Subject: Re: timestamp/function question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group