Daylight saving time falsified rukovoditel date_diff

[Eric]

After investigation about an issue from this topic: viewtopic.php?f=2&t=3559 it was possible to identify the problem.

The timestamp used for days_diff is not working in combination with daylight saving times as many countries have.

In Germany for example we have two times a year to change the clock to summer or winter time, for winter we take an hour away in spring we add this hour.

31.10.2021 winter -1 hour
27.03.2022 summer +1 hour

See screenshot taken from personal demo 1129


Would be great to see this problem solved soon.

[Eric]

Could you reproduce and say something about this?

[support]

I can say that summer is not used in code. My mistake. I have added in plan to fix it. But I have to think hot it can be fixed. Probably some extra configuration etc.

[Eric]

Is this fixed in 3.1 ?

[support]

not yet.

[Eric]

Hello Sergey,

we realy need a fix for this issue please.

Regards

[support]

I'm afraid there is no way to fix it. PHP and Mysql have the same timezone. PHP handle summer time Mysql not. I don't know how to fix it.
Tyr to use different timezone.