Page 1 of 1

Daylight saving time falsified rukovoditel date_diff

Posted: 19 Mar 2022, 05:19
by 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
Image

Would be great to see this problem solved soon.

Re: Daylight saving time falsified rukovoditel date_diff

Posted: 28 Mar 2022, 11:16
by Eric
Could you reproduce and say something about this?

Re: Daylight saving time falsified rukovoditel date_diff

Posted: 07 Apr 2022, 09:13
by 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.

Re: Daylight saving time falsified rukovoditel date_diff

Posted: 03 May 2022, 23:13
by Eric
Is this fixed in 3.1 ?

Re: Daylight saving time falsified rukovoditel date_diff

Posted: 05 May 2022, 09:56
by support
not yet.

Re: Daylight saving time falsified rukovoditel date_diff

Posted: 11 Jun 2022, 02:13
by Eric
Hello Sergey,

we realy need a fix for this issue please.

Regards

Re: Daylight saving time falsified rukovoditel date_diff

Posted: 30 Apr 2023, 10:37
by 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.