#77702Use moment.js and ISO-8601 dates in the backend
Description
The backend currently passes around a weird combination of true UTC timestamps and “adjusted UTC” timestamps which are offset by the server timezone offset to UTC. The latter are also stored in the database.
A better solution is to use ISO-8601 dates as widespread as possible and only convert them to/from timestamps at a single location. This way, everything gets more obvious and we can finally tackle using real UTC timestamps in the database.
Reviews 3
Related issues 3
- Task #78953Custom FormDataProvider breaks with date related changes
- Bug #79249TCA fields with eval types "time" or "timesec" are incorrectly stored in the database
- Bug #83240TCA field with type=input, eval=date with range is broken, always lower range value is applied because of int cast of incoming value before ISO-8601->unix timestamp conversion.