to_date gives odd results - Mailing list pgsql-bugs

From Robert Treat
Subject to_date gives odd results
Date
Msg-id 200708301716.57205.xzilla@users.sourceforge.net
Whole thread Raw
Responses Re: to_date gives odd results
List 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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #3588: coalesce not working in join
Next
From: "Marshall, Steve"
Date:
Subject: Re: BUG #3504: Some listening sessions never return from writing, problems ensue