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

From Reid Thompson
Subject Re: function for current date-time
Date
Msg-id 1161025404.5517.2.camel@jhereg
Whole thread Raw
In response to function for current date-time  ("Harpreet Dhaliwal" <harpreet.dhaliwal01@gmail.com>)
List pgsql-general
On Mon, 2006-10-16 at 14:56 -0400, 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

test=# select now();
              now
-------------------------------
 2006-10-16 15:03:13.174644-04
(1 row)


pgsql-general by date:

Previous
From: Vivek Khera
Date:
Subject: Re: old Pg interface
Next
From: "Carlos H. Reimer"
Date:
Subject: RES: RES: Dates rejected