Thread: Internal time stamps?
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
On Tue, Nov 24, 2009 at 1:26 PM, Aaron <niccoli00@yahoo.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.