Incorrect timestamp on Paypal payments

[loppan]

Hi, just noticed something weird.

I'm on VirtueMart 3.6.10 (10211) & Joomla 3.9.19.

When a customer pays with Paypal, the order creation date ("created_on" in the virtuemart_orders table) is two hours off.

I started to investigate and I found that the timestamp is actually correct in most places.

In the order view in VM admin, the time is correct at the top (see attached screen1.png).

When I log into Paypal the time is correct also (see attached screen2.png).

However, back to VM admin, in the "Payment Method" are at the bottom, the time is now two hours off (see attached screen3.png).

This has been going on since "forever", I just didn't spot it until now.

I have checked the following :

* "Website time zone" in Joomla global configuration is correct
* I've ssh'ed into the server and checked the server time. It's correct.
* I've logged into Paypal and checked timezone settings. It's also correct.

I also checked the Paypal plugin settings to see if there were any separate time zone settings in there, but I couldn't find any (why would it be ).

This is not a huge deal but it could be problematic when doing accounting, especially on the last day of the fiscal year .

I've searched but couldn't find anything relevant.

Please help .

Best regards

Peter

[AH]

The actual payment date is held in the transaction log

The time difference is odd - but the transaction date could be considered for accounting (no idea how you are doing your accounting)

[loppan]

Hi AH and thanks for checking in

Actually, in the transaction log I get a third date :O.

Please see attached screenshot, this is for the same order.

So now we have 3 different timestamps for the same order .

I have a feeling that the transaction log shows the customer's local time, which is not very useful to me.

Now I'm even more confused .

Cheers

Peter