I have this problem when I ship my order. the date field created_at is stored with difference of 4 hours. it's the same problem with sales_flat_shipment_track. ex: I shipped today at 11:56AM, but in my db, I have 2015-10-07 15:56:22

Do you have an explanation?


1 Answer 1


I'm guessing you're located on the east coast and currently on Eastern Time, which is 4 hours earlier than UTC/GMT. Magento saves all of its timestamps in standard UTC/GMT time, so you can display times adjusted to your locale correctly.

Note this only applies to native Magento modules. If you have custom extension, you have to adjust the times yourself for saving and displaying.

  • ok, thank you very much for this explanation Oct 7, 2015 at 20:04
  • Feel free to mark it as the answer if it was.
    – laketuna
    Oct 9, 2015 at 1:23

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.