Re: function for current date-time

Harpreet Dhaliwal wrote:
> Hi,
> I have a timestamp field in my table and want to set a default value of
> current date/time for it.
> What should i enter as its default value? is there any function like
> now() in postgres?
>
> Thanks,
> ~Harpreet

http://www.postgresql.org/docs/8.1/interactive/functions-datetime.html#FUNCTIONS-DATETIME-CURRENT