timestamps - Mailing list pgsql-sql

From David Rugge
Subject timestamps
Date
Msg-id 99110221560802.00836@joplin
Whole thread Raw
Responses Re: [SQL] timestamps  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
I created a table using this statement:

create table timestamptest (creation_date timestamp default text 'now')

But I get the creation date of the table instead of the date of the
transaction. This is the format suggested in the manual to workaround the
default value being set at table creation, but it doesn't work!

What can I do to make a timestamp that is the date the row was inserted into
the table?

--
David Rugge

http://www.mindspring.com/~davidrugge/index.html


pgsql-sql by date:

Previous
From: User &
Date:
Subject: why don't this create table work?
Next
From: Mathijs Brands
Date:
Subject: Re: [SQL] why don't this create table work?