Thread

1. to_char Bug...

   Arthur M. Kang <arthur@levelogic.com> — 2000-08-21T21:41:09Z

   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)
   

2. Re: to_char Bug...

   Karel Zak <zakkr@zf.jcu.cz> — 2000-08-22T07:41:29Z

   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