to_char Bug... - Mailing list pgsql-bugs

From Arthur M. Kang
Subject to_char Bug...
Date
Msg-id 39A1A1F4.70A82D15@levelogic.com
Whole thread Raw
Responses Re: to_char Bug...  (Karel Zak <zakkr@zf.jcu.cz>)
List pgsql-bugs
The to_char functions seems to be barfing on the AM/PM stamp on hours 12
and 13.  I'm not sure if this is already known, but I thought I would
just submit it...

Arthur

swingwire=# select
to_char(timestamp(date('now'),'12:57:11'::time),'FMMonth DD, YYYY at
HH:MI pm');
           to_char
-----------------------------
 August 21, 2000 at 12:57 am
(1 row)

swingwire=# select
to_char(timestamp(date('now'),'13:57:11'::time),'FMMonth DD, YYYY at
HH:MI pm');
           to_char
-----------------------------
 August 21, 2000 at 01:57 am
(1 row)

swingwire=# select
to_char(timestamp(date('now'),'14:57:11'::time),'FMMonth DD, YYYY at
HH:MI pm');
           to_char
-----------------------------
 August 21, 2000 at 02:57 pm
(1 row)

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: PostgreSQL BugTool Submission
Next
From: Unprivileged user
Date:
Subject: PostgreSQL BugTool Submission