[GENERAL] function for current date-time

[Harpreet Dhaliwal]

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