I think the main problem is that the time is stored with one time zone and displyed with another, and its not converting the data correctly.
That is, when displaying the time, the system needs to convert the timezone stored in the database to the correct system timezone for display.
