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

From: Sam Hokin <sam(at)bsharp(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: bug in to_char(timestamp, text) for times between 12:00 and 14:00
Date: 2000-10-21 05:33:16
Message-ID: Pine.LNX.4.21.0010201758470.1106-100000@cb54085-b.mdsn1.wi.home.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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(at)bsharp(dot)org .... http://www.bsharp.org/sam

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Sam Hokin 2000-10-21 05:40:16 should have been HH12:MI, but bug is there anyway
Previous Message pgsql-bugs 2000-10-20 17:53:09 ESQL-C INSERT Problem