Question on timestamp in psql

From: Robert Rothe <rrothe(at)mindspring(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Question on timestamp in psql
Date: 2000-01-11 16:17:31
Message-ID: 387B579B.D1E7545E@mindspring.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2000-01-11 16:28:39 Re: [GENERAL] Question on timestamp in psql
Previous Message Jeff MacDonald 2000-01-11 15:32:32 Re: [GENERAL] Intro/Win9X