I have a client who recently implemented SAP using the "Insync" module. The Magento app is showing the timezone correctly but the db is showing the timestamps in UTC. The folks at Insync say we need to correct the issue. Is there a way to change how timestamps are created?

  • FYI: I have talked to the client and told them to communicate to Insync that they should be adjusting their app to accommodate the time difference. – brentwpeterson Jun 30 '14 at 13:34
  • 3
    Magento shows the time in local time per the time zone set up in configuration and stores the records with UTC time stamps. That pretty much is how most databases work these days so there is interoperability (think multi-national/multi-timezone). Insync just needs to know the time-zone and adjust accordingly. – Fiasco Labs Jun 30 '14 at 20:36
  • Thanks, that is what I told them but they seem to think we need to change our DB server – brentwpeterson Jul 1 '14 at 13:42
  • 2
    Did you solve your problem? If so, please share your solution and mark it as accepted so that we can learn from it :) – Anna Völkl Nov 8 '14 at 9:10

The solution was to update the connector to read the Magento application for the time instead of the db server.

This solved the problem. (Which really was never a problem)


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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