Quick Links

function for current date-time

From:	"Harpreet Dhaliwal" <harpreet(dot)dhaliwal01(at)gmail(dot)com>
To:	pgsql-general(at)postgresql(dot)org
Subject:	function for current date-time
Date:	2006-10-16 18:56:27
Message-ID:	d86a77ef0610161156h1022b185i84676bcaff63b68@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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

Responses

Re: function for current date-time at 2006-10-16 19:02:34 from Bricklen Anderson
Re: function for current date-time at 2006-10-16 19:03:24 from Reid Thompson
Re: function for current date-time at 2006-10-16 19:17:16 from A. Kretschmer

Browse pgsql-general by date

	From	Date	Subject
Next Message	Richard Broersma Jr	2006-10-16 18:58:08	Re: difference b/w text and varchar datatypes
Previous Message	Harpreet Dhaliwal	2006-10-16 18:54:40	Re: difference b/w text and varchar datatypes