Обсуждение: to_char Bug...

Поиск
Список
Период
Сортировка

to_char Bug...

От
"Arthur M. Kang"
Дата:
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)

Re: to_char Bug...

От
Karel Zak
Дата:
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