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

From: Richard Huxton <dev(at)archonet(dot)com>
To: Antonio Molina <molinaantonio(at)hotmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1954: Bug in to_date('09-10-2005', 'dd-mm-yyyy')
Date: 2005-10-11 17:03:05
Message-ID: 434BF049.9020107@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Antonio Molina wrote:
> The following bug has been logged online:
>
> Bug reference: 1954
> Logged by: Antonio Molina
> Email address: molinaantonio(at)hotmail(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Fuhr 2005-10-11 18:02:57 Re: .pgpass does not work for createlang
Previous Message Karl O. Pinc 2005-10-11 16:19:09 BUG #1956: Plpgsql top-level DECLARE does not share scope with CREATE FUNCTION