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