Issue Bug Closed

#81719DateTime comparisons not possible in 8.7

Uwe Michelfelder 06/27/17, 18:45 updated 07/05/23, 21:38

Description

Comparison based custom queries on DateTime values do not work anymore, because they do not get converted correctly in the Typo3DbQueryParser-> createTypedNamedParameter function.

There in line 501

$plainValue = $this->dataMapper->getPlainValue($value);

The value gets always converted to a Unix Timestamp, although in our case DateTime is used in the database and TCA.

The reason for this is, that in the getPlainValue method of the DataMapper, the second parameter “columnMap” is needed to convert the DateTime values to a string correctly.

Is related to #79473

Reviews 1