date('now') returns 1 year from now? - Mailing list pgsql-general

From Charles Hornberger
Subject date('now') returns 1 year from now?
Date
Msg-id 3.0.5.32.19981230163716.00b82aa0@tabloid.net
Whole thread Raw
List pgsql-general
Plz forgive me if I'm missing something obvious.  I just entered "select
date('now') into psql and got the following:

apx2=> select date('now');
      date
----------
12-31-1999
(1 row)

Clearly today is not the last day of 1999.

The system date (`date` in the shell returns "Wed Dec 30 16:51:03 PST
1998") is correct.

(I'm running Postgres 6.4 on Linux 2.0.35.)

Thanks,
Charlie

pgsql-general by date:

Previous
From: Dave Van Abel
Date:
Subject: Accessing PostgreSQL from Web Page via Perl
Next
From: Charles Hornberger
Date:
Subject: date('now') returns 1 year from now? -- follow-up