Re: BUG #2599: AM/PM doesn't work in to_timestamp in

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Josh Tolley <eggyknap(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2599: AM/PM doesn't work in to_timestamp in
Date: 2006-09-03 01:21:53
Message-ID: 200609030121.k831Lr724210@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Josh Tolley wrote:
>
> The following bug has been logged online:
>
> Bug reference: 2599
> Logged by: Josh Tolley
> Email address: eggyknap(at)gmail(dot)com
> PostgreSQL version: 8.1.4
> Operating system: Fedora Core 5
> Description: AM/PM doesn't work in to_timestamp in the middle of a
> string
> Details:
>
> eggyknap=# select to_timestamp('30 Aug 06:01:03.223 PM 2006', 'DD Mon
> HH:MI:SS.MS AM YYYY'), to_timestamp('30 Aug 2006 06:01:03.223 PM', 'DD Mon
> YYYY HH:MI:SS.MS AM');
> to_timestamp | to_timestamp
> ---------------------------+----------------------------
> 0001-08-30 18:01:03-08 BC | 2006-08-30 18:01:03.223-06
>
> This appears to happen when AM/PM isn't the last element in the string.

Nice report. The attached patch fixes it, and will be in 8.2. I am not
backpatching because someone might be relying on this behavior.

--
Bruce Momjian bruce(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

Attachment Content-Type Size
/bjm/diff text/x-diff 1.6 KB

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2006-09-03 01:30:46 Re: BUG #2600: dblink compile with SSL missing
Previous Message Bruce Momjian 2006-09-02 21:20:54 Re: truncate in combination with deferred triggers