Re: BUG #1954: Bug in to_date('09-10-2005', 'dd-mm-yyyy') - Mailing list pgsql-bugs

From Richard Huxton
Subject Re: BUG #1954: Bug in to_date('09-10-2005', 'dd-mm-yyyy')
Date
Msg-id 434BF049.9020107@archonet.com
Whole thread Raw
In response to BUG #1954: Bug in to_date('09-10-2005', 'dd-mm-yyyy')  ("Antonio Molina" <molinaantonio@hotmail.com>)
List pgsql-bugs
Antonio Molina wrote:
> The following bug has been logged online:
>
> Bug reference:      1954
> Logged by:          Antonio Molina
> Email address:      molinaantonio@hotmail.com
> PostgreSQL version: 7.3
> Operating system:   Linux
> Description:        Bug in to_date('09-10-2005', 'dd-mm-yyyy')
> Details:
>
> We did have a error using TO_DATE() function with 09-10-2005 the result is
> 08-10-2005.

Works OK in 7.4 here. Does it work for other dates, and is that a
daylight-saving-time (or summer-time) change-over date in your locale?

--
   Richard Huxton
   Archonet Ltd

pgsql-bugs by date:

Previous
From: "Magnus Hagander"
Date:
Subject: Re: BUG #1951: Multiple instances of postgres.exe running
Next
From: Michael Fuhr
Date:
Subject: Re: .pgpass does not work for createlang