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