I think I've done this in the past but after combing through all sorts of code I can't seem to find it...

I need to subtract 1 hour from `timestamp` to adjust for my time zone.

SELECT DATE_FORMAT(comments.timestamp, '%b %d, %Y - %I:%i %p') AS timestamp
FROM comments