Postgres Pro
Downloads
Home   >   mailing lists

Re: timestamp 'default' question - Mailing list pgsql-general

From Jeff Fitzmyers
Subject Re: timestamp 'default' question
Date
Msg-id F1D7DBF0-558C-11D7-9482-000A959C6000@cloverpub.com
Whole thread Raw
In response to timestamp 'default' question  (Charles Hauser <chauser@duke.edu>)
List pgsql-general
Tree view 
> w/ default set to 'now', I thought postgres would fill in time - not
> so?

Try now()

CREATE TABLE users (
     creation_date timestamp DEFAULT 'now()' NOT NULL
);

Jeff

pgsql-general by date:

Previous
From: Dousak "May (Phoebus Apollonus)"
Date:
Subject: Re: Function in selection?
Next
From: Jean-Luc Lachance
Date:
Subject: Re: Function in selection?