Issue Epic Accepted

#77562Misbehaviors with datetime values and timezones

Oliver Hader 08/21/16, 21:00 updated 11/13/26, 13:21

Description

This issue serves as an umbrella collector.

We can do little to fix stuff in v7, but we shall fix a lot in v8.

The goals for v8 are:

  • Same DB content as in v7
  • Values written to FormEngine must contain the server’s timezone in the ISO-format
  • FormEngine JS must be aware of the timezone used in BE to write back correct values

Reviews 1

Fix this issue

Start the commit message of your patch with this. Add what the patch does, and the versions it goes to in "Releases:". The changes above were merged or abandoned: read them before you start. How to create a patch

Commit message
[TASK] Misbehaviors with datetime values and timezones Resolves: #77562 Releases: main

Subtasks 36

Files 3

History 29

Show 4 earlier messages
  1. Markus Klein changed description status New Accepted Complexity medium <span data-processor="relativetime" data-value="2017-06-06T18:23:39+00:00" > 06/06/17, 18:23 </span>

  1. Markus Klein changed attached TYPO3 datetime evaluation.pdf attached datetimetest.zip tracker Epic Bug TYPO3 Version 7 PHP Version 5.5 Complexity medium Is Regression 0 <span data-processor="relativetime" data-value="2017-06-07T14:13:02+00:00" > 06/07/17, 14:13 </span>

  2. Markus Klein changed tracker Bug Epic target version Sprint Focus Stabilization Sprint <span data-processor="relativetime" data-value="2017-06-07T14:13:45+00:00" > 06/07/17, 14:13 </span>

  3. Christoph Dörfel commented <span data-processor="relativetime" data-value="2019-04-18T11:31:31+00:00" > 04/18/19, 11:31 </span>

    Since you’re updating bug tickets where some of them are already over 3 years old (https://forge.typo3.org/issues/68651) and finally consider tackling this issue, maybe it would be worth looking at all the issues with dates and time zones, especially when saving dates for future events:
    https://codeblog.jonskeet.uk/2019/03/27/storing-utc-is-not-a-silver-bullet/
    This article is for C# but explains that it might not be enough to just save an ISO 8601 representation of the datetime. Time zone rules can change over time and existing dates in the future have to be updated accordingly. Just FYI.

  4. Susanne Moog commented <span data-processor="relativetime" data-value="2019-04-18T11:42:49+00:00" > 04/18/19, 11:42 </span>

    Thanks for the comment and the link. Basically we are lacking the people to tackle this issue in a broad scope currently (afaik) – if you want to get involved (or know of people interested in helping out) please feel free to join #typo3-cms-coredev on slack – else I’m not seeing any quick fixes on this topic at this point in time.