Thread

1. bug in to_char(timestamp, text) for times between 12:00 and 14:00

   Sam Hokin <sam@bsharp.org> — 2000-10-21T05:33:16Z

   There seems to be a bug in 7.0.2 in the to_char(timestamp,text) function
   when one uses the "am" or "pm" template for times between 12:00 and 14:00:
   
   template1=# select to_char(timestamp '2000-01-01 13:00:00', 'HH12:MM pm');
    to_char 
   ----------
    01:01 am 
   
   Any times between 12:00 and 14:00 show "am" rather than "pm".  It shows
   "pm" correctly for 14:00 and later.
   
   My apologies if you've already addressed this, I haven't searched the
   lists to see if it's already been reported.  
   ---------
   Sam Hokin ..... mailto:sam@bsharp.org .... http://www.bsharp.org/sam
   
   
   

2. Re: bug in to_char(timestamp, text) for times between 12:00 and 14:00

   Karel Zak <zakkr@zf.jcu.cz> — 2000-10-24T08:05:17Z

   On Sat, 21 Oct 2000, Sam Hokin wrote:
   
   > There seems to be a bug in 7.0.2 in the to_char(timestamp,text) function
   > when one uses the "am" or "pm" template for times between 12:00 and 14:00:
   
    AM/PM fixed, fixed, already FIXED! Wait for 7.0.3 or 7.1, please... 
   
   > template1=# select to_char(timestamp '2000-01-01 13:00:00', 'HH12:MM pm');
   >  to_char 
   > ----------
   >  01:01 am 
         ^^^
    MM = month
    MI = minute
   
   
   					Karel