Re: timestamp 'default' question

From: Jeff Fitzmyers <jeff(at)cloverpub(dot)com>
To: Charles Hauser <chauser(at)duke(dot)edu>
Cc: Postgresql General <pgsql-general(at)postgresql(dot)org>
Subject: Re: timestamp 'default' question
Date: 2003-03-13 19:49:47
Message-ID: F1D7DBF0-558C-11D7-9482-000A959C6000@cloverpub.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jean-Luc Lachance 2003-03-13 20:01:17 Re: Function in selection?
Previous Message Dousak May (Phoebus Apollonus) 2003-03-13 19:30:10 Re: Function in selection?