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