Re: timestamp - Mailing list pgsql-sql

From Dan Langille
Subject Re: timestamp
Date
Msg-id 20021007083035.V12832-100000@m20.unixathome.org
Whole thread Raw
In response to timestamp  ("Brian Ward" <brian0@verizon.net>)
List pgsql-sql
On Sun, 6 Oct 2002, Brian Ward wrote:

> How do I create a time stamp column in a table that default to the current
> time
> when a row is inserted?
> I tried putting in now() as the default but I have something wrong
> with the syntax or something I think
> Any one have an example of a table creation script that has a timestamp
> column?

When you have an example which does not do what you want, it is better to
provide that so we can see how to correct it.

I am using : firstlogin   timestamp  default current_timestamp




pgsql-sql by date:

Previous
From: Dan Langille
Date:
Subject: Re: Need some SQL help
Next
From: Dan Langille
Date:
Subject: Re: timestamp