Hello,
Is there problem in displaying post submitted time? Take a look at this thread (strange error in MySQL query) in MySQL Forum, it is displaying one hour but when you look at the replies it shows posted time 1 day, 6 hrs etc.
Is there any problem going on with time display?