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

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:[EMAIL PROTECTED] http://www.bsharp.org/sam

[BUGS] should have been HH12:MI, but bug is there anyway

Sorry, I mistyped that query in my bug report, damaging its credibility, but the bug is actually there when you use "MI" for minutes: template1=# select to_char(timestamp '2000-01-01 13:45:00', 'HH12:MI pm'); to_char ------ 01:45 am - Sam Hokin