#100649Extbase DataMapper doesn't respect datetime when 0 or 0000-00-00 or 0000-00-00 00:00:00 or 00:00:00
Description
When using TCA to set an input to datetime or time, like in the documentation (https://docs.typo3.org/m/typo3/reference-tca/11.5/en-us/ColumnsConfig/Type/Input/DateTime/Properties/DbType.html#time-picker-stored-in-a-datetime-field)
'synced_at' => [
'config' => [
'type' => 'input',
'dbType' => 'time',
'eval' => 'time,null',
],
],
The “core” part is working fine, you can set your field to null or midnight (00:00:00)
But then this line in extbase (https://github.com/TYPO3/typo3/blob/main/typo3/sysext/extbase/Classes/Persistence/Generic/Mapper/DataMapper.php#L315) change it to null no matter what, so you cannot know if your time property is not set (null) or midnight (00:00:00)
// Invalid values are converted to NULL
if (empty($value) || $value === '0000-00-00' || $value === '0000-00-00 00:00:00' || $value === '00:00:00') {
return null;
}
A workaround is to change the type of your property to string, and use an extra getter method to make the conversion yourself.
Reviews 2
Related issues 2
History 624
-
Sebastien Convers changed Related to #99847 <span data-processor="relativetime" data-value="2023-04-18T07:23:45+00:00" > 04/18/23, 07:23 </span>
-
Benni Mack changed Sprint Focus Stabilization Sprint <span data-processor="relativetime" data-value="2023-06-06T12:49:25+00:00" > 06/06/23, 12:49 </span>
-
Benjamin Franzke changed parent task #77562 <span data-processor="relativetime" data-value="2025-03-20T13:11:00+00:00" > 03/20/25, 13:11 </span>
-
Gerrit Code Review pushed patch set 1 for main to change 88836 status
NewUnder Review <span data-processor="relativetime" data-value="2025-03-29T16:47:22+00:00" > 03/29/25, 16:47 </span> -
Gerrit Code Review pushed patch set 2 for main to change 88836 <span data-processor="relativetime" data-value="2025-03-30T05:13:14+00:00" > 03/30/25, 05:13 </span>
-
Gerrit Code Review pushed patch set 3 for main to change 88836 <span data-processor="relativetime" data-value="2025-03-30T18:53:38+00:00" > 03/30/25, 18:53 </span>
-
Gerrit Code Review pushed patch set 4 for main to change 88836 <span data-processor="relativetime" data-value="2025-03-31T21:02:19+00:00" > 03/31/25, 21:02 </span>
-
Georg Ringer changed Related to #106467 <span data-processor="relativetime" data-value="2025-04-03T06:25:03+00:00" > 04/03/25, 06:25 </span>
-
Gerrit Code Review pushed patch set 5 for main to change 88836 <span data-processor="relativetime" data-value="2025-04-03T19:21:58+00:00" > 04/03/25, 19:21 </span>
-
Gerrit Code Review pushed patch set 1 for 13.4 to change 88945 <span data-processor="relativetime" data-value="2025-04-04T09:28:21+00:00" > 04/04/25, 09:28 </span>
-
Gerrit Code Review pushed patch set 6 for main to change 88836 <span data-processor="relativetime" data-value="2025-04-04T12:19:14+00:00" > 04/04/25, 12:19 </span>
-
Gerrit Code Review pushed patch set 2 for 13.4 to change 88945 <span data-processor="relativetime" data-value="2025-04-04T14:10:19+00:00" > 04/04/25, 14:10 </span>
-
Gerrit Code Review pushed patch set 7 for main to change 88836 <span data-processor="relativetime" data-value="2025-04-07T13:57:15+00:00" > 04/07/25, 13:57 </span>
-
Gerrit Code Review pushed patch set 8 for main to change 88836 <span data-processor="relativetime" data-value="2025-04-07T17:31:38+00:00" > 04/07/25, 17:31 </span>
-
Gerrit Code Review pushed patch set 3 for 13.4 to change 88945 <span data-processor="relativetime" data-value="2025-04-07T17:32:44+00:00" > 04/07/25, 17:32 </span>
-
Gerrit Code Review pushed patch set 9 for main to change 88836 <span data-processor="relativetime" data-value="2025-04-11T09:02:07+00:00" > 04/11/25, 09:02 </span>
-
Gerrit Code Review pushed patch set 4 for 13.4 to change 88945 <span data-processor="relativetime" data-value="2025-04-11T13:26:20+00:00" > 04/11/25, 13:26 </span>
-
Gerrit Code Review pushed patch set 10 for main to change 88836 <span data-processor="relativetime" data-value="2025-04-11T13:29:18+00:00" > 04/11/25, 13:29 </span>
-
Gerrit Code Review pushed patch set 11 for main to change 88836 <span data-processor="relativetime" data-value="2025-05-11T11:20:22+00:00" > 05/11/25, 11:20 </span>
-
Gerrit Code Review pushed patch set 12 for main to change 88836 <span data-processor="relativetime" data-value="2025-05-11T14:33:12+00:00" > 05/11/25, 14:33 </span>
-
Gerrit Code Review pushed patch set 13 for main to change 88836 <span data-processor="relativetime" data-value="2025-05-20T12:19:21+00:00" > 05/20/25, 12:19 </span>
-
Gerrit Code Review pushed patch set 5 for 13.4 to change 88945 <span data-processor="relativetime" data-value="2025-05-23T10:31:31+00:00" > 05/23/25, 10:31 </span>
-
Benjamin Franzke commented and changed status
Under ReviewResolved done0 %100 % <span data-processor="relativetime" data-value="2025-05-23T10:45:09+00:00" > 05/23/25, 10:45 </span> -
Benni Mack changed status
ResolvedClosed <span data-processor="relativetime" data-value="2025-12-02T14:33:50+00:00" > 12/02/25, 14:33 </span>
Applied in changeset commit:2f3bdf6e4f974ef882d27adddd74e574ca5bad4a.