Issue Bug Closed

#94699Extbase: DateTimeImmutables won't be stored as UTC

Moritz Ngo 08/03/21, 16:03 updated 03/20/25, 13:15

Description

When using a \DateTimeImmutable property and TCA dbType is set to date, time or datetime then the actual value won’t get persisted as UTC in the database.

After the value has been persisted, the value will be read from the database and interpreted as UTC, thus the model will have a wrong \DateTimeImmutable property value.

The issue is caused, by \TYPO3\CMS\Extbase\Persistence\Generic\Mapper\DataMapper::getPlainValue() where timezone will be set to UTC.
The \DateTimeImmutable won’t be updated with the “new” timezone, thus a wrong value will be stored.

This issue occurs in the following TYPO3 CMS versions:

TYPO3 CMS v11 should not be affected, because the the timezone won’t be altered.

Reviews 1

History 4

  1. Moritz Ngo changed description 08/03/21, 16:04

  2. Moritz Ngo changed description 08/03/21, 16:26

  3. Benjamin Franzke commented and changed status New Closed 03/20/25, 13:15

    Yes, that’s true it’s broken in version below 11, as this issue was fixed in v11.0 only (as it is quite a drastic change) with the following patch:

    > 64053: [BUGFIX] Do not convert native DATETIME values in Extbase | https://review.typo3.org/c/Packages/TYPO3.CMS/+/64053

    Thanks for you report anyway!

  4. Benjamin Franzke changed Duplicates #91240 03/20/25, 13:15