to_char Bug...

Started by Arthur M. Kangover 25 years ago2 messagesbugs
Jump to latest
#1Arthur M. Kang
arthur@levelogic.com

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)

#2Karel Zak
zakkr@zf.jcu.cz
In reply to: Arthur M. Kang (#1)
Re: to_char Bug...

On Mon, 21 Aug 2000, Arthur M. Kang wrote:

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...

Yes, it's already known and already fixed in the current CVS tree.

Thanks,
Karel