Skip site navigation (1)
Skip section navigation (2)
Just tested "select date('now'::datetime)", and it returns the correct date.
apx2=> select date('now'::datetime);
date
----------
12-30-1998
(1 row)
Charlie
>>>>
Peripheral Links
Header And Logo
|
Site Navigation
date('now') returns 1 year from now? -- follow-up
- From: Charles Hornberger <hornberger@tabloid.net>
- To: pgsql-general@postgresql.org
- Subject: date('now') returns 1 year from now? -- follow-up
- Date: Wed, 30 Dec 1998 16:43:47 -0800
- Message-id: <3.0.5.32.19981230164347.00a2a6f0@tabloid.net>
Just tested "select date('now'::datetime)", and it returns the correct date.
apx2=> select date('now'::datetime);
date
----------
12-30-1998
(1 row)
Charlie
>>>>
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
- Prev by Date: date('now') returns 1 year from now?
- Next by Date: Re: [GENERAL] 88, CREATE FUNCTION ON TABLE
- Previous by thread: date('now') returns 1 year from now?
- Next by thread: Re: [GENERAL] Removing large objects from the db (Q at bottom)
- Indexes: