| From: | Dan Langille <dan(at)langille(dot)org> |
|---|---|
| To: | Brian Ward <brian0(at)verizon(dot)net> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: timestamp |
| Date: | 2002-10-07 12:35:08 |
| Message-ID: | 20021007083035.V12832-100000@m20.unixathome.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dan Langille | 2002-10-07 12:44:32 | Re: timestamp |
| Previous Message | Dan Langille | 2002-10-07 12:27:20 | Re: Need some SQL help |