#96890Wrong processing and display of native datetime(dbType) fields due to server timezone
Description
Wrong processing and display of native datetime(dbType) fields due to server timezone
Inside DatabaseRowDateTimeFields class native datetime (dbType) values are treated as UTC values, whereas the rest uses the local timezone (e.g. BackendUtility::datetime).
This causes the TCA title (bug 1) and readOnly fields (bug 2) to be formatted wrong (with an time offset).
The conversion also breaks the title for time fields (bug 3) completely.
Prerequisite
- Timezone != ‘UTC’, e.g.
timezone: America/New_York(.ddev/config.yaml) - Specified configuration (see below)
Steps to reproduce
Bug 1
- Create a new
DateTime title errorrecord and set mydatetime to12:00 20-02-2022 - Save record
- Look at the record title
- Actual value (wrong time):
Edit DateTime title error "20-02-22 07:00" on page "recordStorage" - Expected value:
Edit DateTime title error "20-02-22 12:00" on page "recordStorage"
dateTimeTitle-saved.png
- Actual value (wrong time):
Bug 2
- Uncomment
readOnlyin TCA and clear cache/reload - Open record from bug 1
- Look at the disable field (mydatetime)
- Actual value (wrong time):
20-02-22 07:00 - Expected value:
20-02-22 12:00
dateTimeTitle-readOnly.png
- Actual value (wrong time):
Bug 3
- Change TCA config for bug 3 and clear cache/reload
- Create a new
DateTime title errorrecord and set mytime to12:00 - Save record
- Actual value:
2022-02-12T07:00:00-05:00 - Expected value:
12:00
dateTimeTitle-time.png
- Actual value:
Configuration
TCA:
return [
'ctrl' => [
'title' => 'DateTime title error',
'label' => 'mydatetime', // Bug 1 and 2
// 'label' => 'time', // Bug 3
],
'columns' => [
// Bug 1 and 2
'mydatetime' => [
'label' => 'mydatetime',
'config' => [
'type' => 'input',
'renderType' => 'inputDateTime',
'dbType' => 'datetime',
'eval' => 'datetime,null',
// 'readOnly' => true, // Bug 2
],
],
// Bug 3
'mytime' => [
'label' => 'mytime',
'config' => [
'type' => 'input',
'renderType' => 'inputDateTime',
'dbType' => 'time',
'eval' => 'time,null',
],
],
],
'types' => [
'0' => ['showitem' => 'mydatetime,mytime'],
],
];
SQL:
mydatetime datetime default NULL,
mytime time default NULL,
Source of the problem
- the conversion in DatabaseRowDateTimeFields:47
Classes using this value (as far as I know)
- Bug 1: TcaRecordTitle:320,360
- Example dataflow
- Database:
2022-02-22 12:00 - DatabaseRowDateTimeFields: generates a string like
2022-02-22T07:00:00-05:00(UTC) - TcaRecordTitle: converted to a timestamp by
strtotimeto1645531200 - TcaRecordTitle: converted by
BackendUtility::datetime(with date function, formats in server timezone) to2022-02-22 07:00
- Database:
- Example dataflow
- Bug 2: InputDateTimeElement:114
- Bug 3: TcaRecordTitle???
- Custom functions using
formattedLabel_userFunc
Reviews 3
Related issues 2
Files 3
History 1032
Show 67 earlier messages
-
Gabe Troyan changed assigned to Gabe Troyan <span data-processor="relativetime" data-value="2022-02-15T17:24:55+00:00" > 02/15/22, 17:24 </span>
-
Imko Schumacher commented <span data-processor="relativetime" data-value="2022-02-15T17:55:32+00:00" > 02/15/22, 17:55 </span>
-
Imko Schumacher commented and changed TYPO3 Version
1113 <span data-processor="relativetime" data-value="2023-12-04T17:32:11+00:00" > 12/04/23, 17:32 </span>Bugs are still present in TYPO3 v13 (tested with
9e1e9493ff5e0b615e4921b2612226c684759d3f).Updated TCA;
return [ 'ctrl' => [ 'title' => 'DateTime title error', 'label' => 'mydatetime', // Bug 1 and 2 // 'label' => 'mytime', // Bug 3 ], 'columns' => [ // Bug 1 and 2 'mydatetime' => [ 'label' => 'mydatetime', 'config' => [ 'type' => 'datetime', 'format' => 'datetime', 'dbType' => 'datetime', 'nullable' => true, // 'readOnly' => true, // Bug 2 ], ], // Bug 3 'mytime' => [ 'label' => 'mytime', 'config' => [ 'type' => 'datetime', 'format' => 'time', 'dbType' => 'time', 'nullable' => true, ], ], ], 'types' => [ '0' => ['showitem' => 'mydatetime,mytime'], ], ]; -
Markus Klein changed TYPO3 Version
1311 <span data-processor="relativetime" data-value="2023-12-09T19:42:29+00:00" > 12/09/23, 19:42 </span> -
Markus Klein changed Related to #61110 <span data-processor="relativetime" data-value="2024-07-10T07:20:56+00:00" > 07/10/24, 07:20 </span>
-
Benjamin Franzke changed Related to #105643 <span data-processor="relativetime" data-value="2024-11-19T22:02:25+00:00" > 11/19/24, 22:02 </span>
-
Gerrit Code Review pushed patch set 3 for main to change 86925 status
NewUnder Review <span data-processor="relativetime" data-value="2024-11-19T22:45:37+00:00" > 11/19/24, 22:45 </span>
-
Gerrit Code Review pushed patch set 4 for main to change 86925 <span data-processor="relativetime" data-value="2024-11-20T05:14:59+00:00" > 11/20/24, 05:14 </span>
-
Gerrit Code Review pushed patch set 5 for main to change 86925 <span data-processor="relativetime" data-value="2024-11-20T06:33:26+00:00" > 11/20/24, 06:33 </span>
-
Gerrit Code Review pushed patch set 6 for main to change 86925 <span data-processor="relativetime" data-value="2024-11-20T21:12:11+00:00" > 11/20/24, 21:12 </span>
-
Gerrit Code Review pushed patch set 7 for main to change 86925 <span data-processor="relativetime" data-value="2024-11-20T21:43:19+00:00" > 11/20/24, 21:43 </span>
-
Gerrit Code Review pushed patch set 8 for main to change 86925 <span data-processor="relativetime" data-value="2025-03-19T17:50:33+00:00" > 03/19/25, 17:50 </span>
-
Gerrit Code Review pushed patch set 9 for main to change 86925 <span data-processor="relativetime" data-value="2025-03-19T20:48:20+00:00" > 03/19/25, 20:48 </span>
-
Gerrit Code Review pushed patch set 10 for main to change 86925 <span data-processor="relativetime" data-value="2025-03-19T21:13:25+00:00" > 03/19/25, 21:13 </span>
-
Gerrit Code Review pushed patch set 11 for main to change 86925 <span data-processor="relativetime" data-value="2025-03-20T03:01:11+00:00" > 03/20/25, 03:01 </span>
-
Gerrit Code Review pushed patch set 12 for main to change 86925 <span data-processor="relativetime" data-value="2025-03-20T05:49:45+00:00" > 03/20/25, 05:49 </span>
-
Gerrit Code Review pushed patch set 13 for main to change 86925 <span data-processor="relativetime" data-value="2025-03-20T07:31:19+00:00" > 03/20/25, 07:31 </span>
-
Gerrit Code Review pushed patch set 14 for main to change 86925 <span data-processor="relativetime" data-value="2025-03-20T10:28:40+00:00" > 03/20/25, 10:28 </span>
-
Gerrit Code Review pushed patch set 15 for main to change 86925 <span data-processor="relativetime" data-value="2025-03-21T06:11:15+00:00" > 03/21/25, 06:11 </span>
-
Gerrit Code Review pushed patch set 16 for main to change 86925 <span data-processor="relativetime" data-value="2025-03-21T07:25:51+00:00" > 03/21/25, 07:25 </span>
-
Gerrit Code Review pushed patch set 17 for main to change 86925 <span data-processor="relativetime" data-value="2025-03-27T10:24:32+00:00" > 03/27/25, 10:24 </span>
-
Gerrit Code Review pushed patch set 6 for main to change 88826 <span data-processor="relativetime" data-value="2025-03-29T12:55:09+00:00" > 03/29/25, 12:55 </span>
-
Gerrit Code Review pushed patch set 7 for main to change 88826 <span data-processor="relativetime" data-value="2025-03-29T13:39:26+00:00" > 03/29/25, 13:39 </span>
-
Gerrit Code Review pushed patch set 8 for main to change 88826 <span data-processor="relativetime" data-value="2025-03-31T07:27:31+00:00" > 03/31/25, 07:27 </span>
-
Benjamin Franzke changed parent task #77562 <span data-processor="relativetime" data-value="2025-03-31T07:50:20+00:00" > 03/31/25, 07:50 </span>
-
Gerrit Code Review pushed patch set 9 for main to change 88826 <span data-processor="relativetime" data-value="2025-04-02T10:41:06+00:00" > 04/02/25, 10:41 </span>
-
Gerrit Code Review pushed patch set 10 for main to change 88826 <span data-processor="relativetime" data-value="2025-04-03T18:49:37+00:00" > 04/03/25, 18:49 </span>
-
Benjamin Franzke commented and changed status
Under ReviewResolved done0 %100 % <span data-processor="relativetime" data-value="2025-04-04T07:30:09+00:00" > 04/04/25, 07:30 </span>Applied in changeset commit:da29fc6fe375cc03ea870f79697e7a7458de2402.
-
Gerrit Code Review pushed patch set 1 for 13.4 to change 88944 status
ResolvedUnder Review <span data-processor="relativetime" data-value="2025-04-04T08:17:02+00:00" > 04/04/25, 08:17 </span> -
Gerrit Code Review pushed patch set 2 for 13.4 to change 88944 <span data-processor="relativetime" data-value="2025-04-04T08:26:33+00:00" > 04/04/25, 08:26 </span>
-
Benjamin Franzke commented and changed status
Under ReviewResolved <span data-processor="relativetime" data-value="2025-04-04T09:50:08+00:00" > 04/04/25, 09:50 </span>Applied in changeset commit:35164c8c9a93d379fbd065bb5fb77340cb150951.
-
Benni Mack changed status
ResolvedClosed <span data-processor="relativetime" data-value="2025-12-02T14:33:50+00:00" > 12/02/25, 14:33 </span>
Some hints for possible solutions:
Option A
Remove the first part of the if clause or even the whole file (DatabaseRowDateTimeFields):InputDateTimeElement2014-12-31 23:59:59) betterOption B (simple, but not lasting)
Remove the
Problems:@ . ‘ UTC’@in DatabaseRowDateTimeFields:47