Re: [GENERAL] Date column that defaults to 'now'

[Gaetano Mendola]

John Siracusa wrote:

> On 1/5/04 4:29 PM, Michael Glaesemann wrote:
>
>>(If you're not the John Siracusa who writes for Ars Technica, the
>>sentiment still holds. :) )
>
>
> I am everywhere!
>
> (worked, thanks to both of you who replied :)
Anyway the two solution solve different problems:

1) DEFAULT now()
        you'll have the timestamp of transaction
2) DEFAULT timeofday()
        you'll have the timestamp of insertion


Regards
Gaetano Mendola
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
              http://archives.postgresql.org