Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
to_date gives odd results
- From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
- To: pgsql-bugs(at)postgresql(dot)org
- Subject: to_date gives odd results
- Date: Thu, 30 Aug 2007 17:16:57 -0400
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
- Follow-Ups:
- Re: to_date gives odd results
- From: Tom Lane
- Re: to_date gives odd results
- Prev by Date: Re: BUG #3588: coalesce not working in join
- Next by Date: Re: BUG #3504: Some listening sessions never return from writing, problems ensue
- Previous by thread: to_tsquery stack overflow
- Next by thread: Re: to_date gives odd results
- Indexes: