Hi, I just noticed a difference in output with the to_date() function
between 8.3.7 and 8.4.B2.
Running the following query on PG 8.3.7
select
to_char(2009,'') as year,
to_char(3,'09') as month,
to_date(to_char(2009,'')||to_char(3,'99') ,'MM') as method1,
to_dat
The following bug has been logged online:
Bug reference: 4862
Logged by: Jeremy Ford
Email address: jeremf...@gmail.com
PostgreSQL version: 8.4 RC1
Operating system: Fedora 10 i386
Description:different results in to_date() between 8.3.7 & 8.4.RC1
Details:
Run
Oracle 9i:
YEAR MONTH METHOD1 METHOD2
2009 03 1/03/2009 1/03/2009
Oracle 10g:
YEAR MONTHMETHOD1 METHOD2
2009 03 1/03/20091/03/2009
Regards,
Jeremy.
On Sat, Jun 20, 2009 at 2:03 AM, Tom Lane wrote:
> Brendan Jurd
--
1/03/2009
1 row selected
SELECT TO_DATE('2009 03', ' MM') AS bogusspace FROM dual
BOGUSSPACE
--
1/03/2009
1 row selected
Hope this helps,
Jeremy.
On Mon, Jun 22, 2009 at 4:39 PM, Brendan Jurd wrote:
> 2009/6/22 Je
I've just compiled and run the 8.4.RC2 code. For both of the following
queries I get "0009-03-01"
SELECT to_date(' 2009 03', ' MM') as extraspace; --returns
"0009-03-01"
SELECT to_date('2009 03', ' MM') as bogusspace; --returns "0009-03-01"
Was it the intention to imitate Oracle behavi
