#105550(pseudo) Native dbType=datetime strings in flexforms not working and interpreted as integer
Description
With dbType=datetime in a flexform:
<inputDateTime_4>
<label>inputDateTime_4 dbType=datetime format=date</label>
<config>
<type>datetime</type>
<format>date</format>
<dbType>datetime</dbType>
</config>
</inputDateTime_4>
The value is interpreted as integer instead of as a string because the DatabaseRowDateTimeFields is only applied to real columns and not to flexform columns.
Which then results in flexform dbType datetime’s to be interpreted as integers by:
https://github.com/TYPO3/typo3/blob/3343d780e6438a8de02494717fb5761e461f65b9/Build/Sources/TypeScript/backend/form-engine-validation.ts#L156
Therefore a database value like 1960-01-01 05:42:23 is interpreted as 1960 seconds (unix timestamp) which results in a fake-date to be calculated: 1970-01-01T00:32:40Z (32:40 because 1960 = 32 * 60 + 40)
As a result the date is 1970 instead of 1960 as shown below:
flex-dbtype-datetime-parsed-as-integer-timestamp.png
Reviews 3
Files 1
History 29
-
Gerrit Code Review pushed patch set 1 for main to change 86912 status
NewUnder Review <span data-processor="relativetime" data-value="2024-11-06T15:49:15+00:00" > 11/06/24, 15:49 </span> -
Gerrit Code Review pushed patch set 2 for main to change 86912 <span data-processor="relativetime" data-value="2024-11-06T16:07:06+00:00" > 11/06/24, 16:07 </span>
-
Gerrit Code Review pushed patch set 3 for main to change 86912 <span data-processor="relativetime" data-value="2024-11-06T16:13:15+00:00" > 11/06/24, 16:13 </span>
-
Gerrit Code Review pushed patch set 4 for main to change 86912 <span data-processor="relativetime" data-value="2024-11-06T16:31:30+00:00" > 11/06/24, 16:31 </span>
-
Gerrit Code Review pushed patch set 5 for main to change 86912 <span data-processor="relativetime" data-value="2024-11-06T17:04:02+00:00" > 11/06/24, 17:04 </span>
-
Gerrit Code Review pushed patch set 1 for 13.4 to change 87067 <span data-processor="relativetime" data-value="2024-11-19T19:31:17+00:00" > 11/19/24, 19:31 </span>
-
Gerrit Code Review pushed patch set 1 for 12.4 to change 87068 <span data-processor="relativetime" data-value="2024-11-19T19:37:17+00:00" > 11/19/24, 19:37 </span>
-
Benjamin Franzke commented and changed status
Under ReviewResolved done0 %100 % <span data-processor="relativetime" data-value="2024-11-19T19:50:09+00:00" > 11/19/24, 19:50 </span> -
Benni Mack changed status
ResolvedClosed <span data-processor="relativetime" data-value="2025-08-12T14:35:37+00:00" > 08/12/25, 14:35 </span>
Applied in changeset commit:55ab3de74f9c24af0705e064bcb1ed3471643a36.