Question on timestamp in psql - Mailing list pgsql-general

From Robert Rothe
Subject Question on timestamp in psql
Date
Msg-id 387B579B.D1E7545E@mindspring.com
Whole thread Raw
Responses Re: [GENERAL] Question on timestamp in psql  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
When I type the following at the psql prompt:

select timestamp('now');

...I always get december 31, 1999.

If I use 'now' as the rvalue to a SET, or within an INSERT, it returns
the correct date.

Is this a known problem?  I'm running 6.5.2-1.

Thanks,
Rob

pgsql-general by date:

Previous
From: admin
Date:
Subject: Re: [GENERAL] Re: can't seem to use index
Next
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] Question on timestamp in psql