date('now') returns 1 year from now? -- follow-up

From: Charles Hornberger <hornberger(at)tabloid(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: date('now') returns 1 year from now? -- follow-up
Date: 1998-12-31 00:43:47
Message-ID: 3.0.5.32.19981230164347.00a2a6f0@tabloid.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Just tested "select date('now'::datetime)", and it returns the correct
date.

apx2=> select date('now'::datetime);

date

----------

12-30-1998

(1 row)

Charlie

>>>>

<excerpt>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

</excerpt><<<<<<<<

Attachment Content-Type Size
unknown_filename text/enriched 604 bytes

Browse pgsql-general by date

  From Date Subject
Next Message Jose' Soares 1998-12-31 09:05:34 Re: [GENERAL] 88, CREATE FUNCTION ON TABLE
Previous Message Charles Hornberger 1998-12-31 00:37:16 date('now') returns 1 year from now?