Re: function for current date-time

[Bricklen Anderson <banderson@xxxxxxxxxxxx>]

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