am Mon, dem 16.10.2006, um 14:56:27 -0400 mailte Harpreet Dhaliwal folgendes:
> 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?
Yes, now() ;-)
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=# selec
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-d
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
