4

I have migrated Magento 1.9.3.1 to Magento 2.3.0

I have setup timezone India Standard Time(Asia/Kolkata).

After migration created_time have differences of 5:30 hours. How can I fix the issue?

For example:

In Magento 1.9 order purchased on: Jun 18, 2019 06:46:43 AM

But In Magento 2.3.0 order purchased_date: Jun 18, 2019 12:16:43 PM
  • Magento 1.9.3.1 - which timezone have ? – Anas Mansuri Jun 18 '19 at 10:34
  • India Standard Time – Vinod Kumar Jun 18 '19 at 10:47
1

Please check your MySQL server timezone. What happens usually is your MySQL server might be set to UTC timezone hence time in database is considered as UTC, now as you have set Magento Timezone to Indian Standard Time, the time showed in Magento is +5:30 hrs of UTC. So change your MySQL server timezone to IST.

| improve this answer | |
  • Yes, it is UTC timezone. – Vinod Kumar Jun 19 '19 at 5:19
  • In that case please change your MySQL timezone to IST. – Abdul Pathan Jun 19 '19 at 10:10

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.