From: | APseudoUtopia <apseudoutopia(at)gmail(dot)com> |
---|---|
To: | Aaron <niccoli00(at)yahoo(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Internal time stamps? |
Date: | 2009-11-26 03:51:16 |
Message-ID: | 27ade5280911251951l60ffd56emab181d861024e58e@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Tue, Nov 24, 2009 at 1:26 PM, Aaron <niccoli00(at)yahoo(dot)com> wrote:
> Does postgresql have any kind of internal time stamps for a table entry? I
> can create a field that is 'timestamp' and store it there, I was just
> wondering if it was already done internally. I'd hate to duplicate
> something it already does. :-)
> If it does store it internally, how do you access it?
> Thanks!!
> Aaron
To the best of my knowledge:
Internal timestamps do not exist. If you want to store a timestamp of
when a row was inserted, just use a TIMESTAMP type column (with- or
without- time zone; WITH TIME ZONE is recommended) and insert
CURRENT_TIMESTAMP or NOW or whatever function you wanna use.
From | Date | Subject | |
---|---|---|---|
Next Message | Rikard Bosnjakovic | 2009-11-26 05:00:03 | Re: Merging two GROUP BY-queries |
Previous Message | Mark Styles | 2009-11-26 01:48:45 | Re: Merging two GROUP BY-queries |