From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | to_date gives odd results |
Date: | 2007-08-30 21:16:57 |
Message-ID: | 200708301716.57205.xzilla@users.sourceforge.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
example from docs:
pagila=# select to_date('05 Dec 2000', 'DD Mon YYYY');
to_date
------------
2000-12-05
(1 row)
slight modification:
pagila=# select to_date('05 December 2000', 'DD Month YYYY');
to_date
---------------
0001-12-05 BC
(1 row)
I can't imagine that's expected behavior.... bug?
oh,
pagila=# select version();
version
-------------------------------------------------------------
PostgreSQL 8.2.4 on i386-pc-solaris2.10, compiled by cc -Xa
(1 row)
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
From | Date | Subject | |
---|---|---|---|
Next Message | Marshall, Steve | 2007-08-30 21:44:20 | Re: BUG #3504: Some listening sessions never return from writing, problems ensue |
Previous Message | Tom Lane | 2007-08-30 17:51:00 | Re: BUG #3588: coalesce not working in join |