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... ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html