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.
Daylight saving time falsified rukovoditel date_diff
Re: Daylight saving time falsified rukovoditel date_diff
Could you reproduce and say something about this?
- support
- Site Admin
- Posts: 6215
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: Daylight saving time falsified rukovoditel date_diff
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
Is this fixed in 3.1 ?
Re: Daylight saving time falsified rukovoditel date_diff
Hello Sergey,
we realy need a fix for this issue please.
Regards
we realy need a fix for this issue please.
Regards
- support
- Site Admin
- Posts: 6215
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: Daylight saving time falsified rukovoditel date_diff
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.
Tyr to use different timezone.