Where is time zone taken from

Hi,
Can you tell me where your extension is picking up the date/time zone from?
Since I updated to the latest version of your extension I have a problem with transferring over data because my date/time fields are being changed by 1 hour. Both my servers and SQL databases are on the same time zone so that can’t be where your extension is getting it’s time zone from.
The problem is that I have an order at 2021-03-28 02:32:52 and your extension is changing that one hour back to 2021-03-28 01:32:52 but this is an invalid date/time because the time moves forward one hour on the 28th March.
Thanks in advance
Arjuna

1 answer

Profile photo of Mall Staff 171930.00 $tone October 18, 2021
Public

Hi Arjuna,
I am sorry for replying to you this late as our team has just been back from our weekend. 

Can you tell me where your extension is picking up the date/time zone from?

Our module gets the actual Timezone setting from your M1 database (general/locale/timezone)
and then converts to the UTC time before storing it into the M2 database (this is a new working rule in M2)

The problem is that I have an order at 2021-03-28 02:32:52 and your extension is changing that one hour back to 2021-03-28 01:32:52 but this is an invalid date/time because the time moves forward one hour on the 28th March.

Did you view that values directly in your databases? As indicated above, the DateTime value you saw in the M2 database was stored with the UTC timezone (2021-03-28 01:32:52). 
 
Please have a look again and let me know if you need further assistance.

Regards,
Mall.

#1

Please login or Register to Submit Answer

Written By

Comments