Horton

to_char Bug...

Arthur M. Kang <arthur@levelogic.com>

View thread
From: "Arthur M. Kang" <arthur@levelogic.com>
To: bugs@postgresql.org
Date: 2000-08-21T21:41:09Z
Lists: 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)