juuser
Well-Known Member
Couple of days ago I noticed a strange thing where some of the dates in my list changed to one day earlier. I changed these back and now these are again moved one day back. In my form/list I have these in format Y-m-d. Element settings are default (including store date as utc).
I checked the database value when the date had changed a day earlier and it showed 2019-01-24 20:00:00. As my timezone is UTC+2, it naturally shows 2019-01-24 in my list.
Now, when I change it back to 2019-01-25, record in database shows 2019-01-24 22:00:00, so with my timezone (+2h) it is showing the correct date (2019-01-25).
What could be the reason for this anomaly? I haven't changed any time/timezone related settings in my server or Joomla configuration. And the dates (times) just keep changing two hours backwards.
I checked the database value when the date had changed a day earlier and it showed 2019-01-24 20:00:00. As my timezone is UTC+2, it naturally shows 2019-01-24 in my list.
Now, when I change it back to 2019-01-25, record in database shows 2019-01-24 22:00:00, so with my timezone (+2h) it is showing the correct date (2019-01-25).
What could be the reason for this anomaly? I haven't changed any time/timezone related settings in my server or Joomla configuration. And the dates (times) just keep changing two hours backwards.