Thread: BUG #1954: Bug in to_date('09-10-2005', 'dd-mm-yyyy')

BUG #1954: Bug in to_date('09-10-2005', 'dd-mm-yyyy')

From
"Antonio Molina"
Date:
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.

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

From
Richard Huxton
Date:
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