Postgres Pro
Downloads
Home   >   mailing lists

Re: function for current date-time - Mailing list pgsql-general

From Bricklen Anderson
Subject Re: function for current date-time
Date
Msg-id 4533D74A.6020706@presinet.com
Whole thread Raw
In response to function for current date-time  ("Harpreet Dhaliwal" <harpreet.dhaliwal01@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Richard Broersma Jr
Date:
Subject: Re: difference b/w text and varchar datatypes
Next
From: Vivek Khera
Date:
Subject: Re: RES: Dates rejected