Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
date('now') returns 1 year from now?
- From: Charles Hornberger <hornberger(at)tabloid(dot)net>
- To: pgsql-general(at)postgresql(dot)org
- Subject: date('now') returns 1 year from now?
- Date: Wed, 30 Dec 1998 16:37:16 -0800
- Message-id: <3.0.5.32.19981230163716.00b82aa0@tabloid.net> <text/plain>
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: Accessing PostgreSQL from Web Page via Perl
- Next by Date: date('now') returns 1 year from now? -- follow-up
- Previous by thread: Accessing PostgreSQL from Web Page via Perl
- Next by thread: date('now') returns 1 year from now? -- follow-up
- Indexes: