Hi, I'm working with 7.0.2, so this might be an old bug. I saw some
other bugs mentioned in this newsgroup involving to_char were said to
be resolved for 7.1.0, but I just thought I'd volunteer it anyway...
db1=# select flastpostdate, to_char(flastpostdate, 'hh:mi:ss mon-dd-yy
am') from tThreads order by flastpostdate desc limit 1;
flastpostdate | to_char
------------------------+-----------------------
2001-08-14 13:22:02-07 | 01:22:02 aug-14-01 am
(1 row)
It displays results that should be pm as am. Seems to work for other
hours, though...