Project

General

Profile

Actions
Copy link

Feature #105549

closed

Epic #77562: Misbehaviors with datetime values and timezones

Replace fake UTC0 ISO8601 date strings by unqualified (local) ISO8601

Added by Benjamin Franzke 8 months ago. Updated 3 months ago.

Status:
Resolved
Priority:
Should have
Assignee:
-
Category:
DataHandler aka TCEmain
Target version:
14.0
Start date:
2024-11-06
Due date:
% Done:

100%

Estimated time:
PHP Version:
Tags:
Complexity:
Sprint Focus:

Description

Goal is to align DataHandler to
  • accept unqualified ISO8601 and interpret that as server localtime (which is currently faked using a UTC0 that is actually interpreted as unqualified localtime)
  • support datetime offsets for persistence, for DataHanlder-as-a-API usage, without "unexpected" results (that we've seen reports for in the past)

Related issues 5 (1 open — 4 closed)

Related to TYPO3 Core - Task #104309: Use ISO dates in FormEngine date handlingClosed2024-07-04

Actions
Related to TYPO3 Core - Task #105643: Transform all dates in DatabaseRowDateTimeFields to DateTimeUnder Review2024-11-19

Actions
Related to TYPO3 Core - Task #105661: Add functional DataHandler tests for type=datetimeResolved2024-11-20

Actions
Related to TYPO3 Core - Bug #106364: DatetimeElement stores format=time in seconds, while extbase interprets it as timezone-offset-mapped UTC timestamp, when php timezone is not UTCResolved2025-03-12

Actions
Related to TYPO3 Core - Bug #106595: 1970-01-01 in tt_content.date field after translation with date field disabled for editorsResolvedBenjamin Franzke2025-04-22

Actions
Actions
Copy link
 #1

Updated by Benjamin Franzke 8 months ago

  • Related to Task #104309: Use ISO dates in FormEngine date handling added
Actions
Copy link
 #2

Updated by Gerrit Code Review 8 months ago

  • Status changed from New to Under Review

Patch set 6 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/86888

Actions
Copy link
 #3

Updated by Gerrit Code Review 8 months ago

Patch set 7 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/86888

Actions
Copy link
 #4

Updated by Gerrit Code Review 8 months ago

Patch set 8 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/86888

Actions
Copy link
 #5

Updated by Gerrit Code Review 8 months ago

Patch set 9 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/86888

Actions
Copy link
 #6

Updated by Gerrit Code Review 8 months ago

Patch set 10 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/86888

Actions
Copy link
 #7

Updated by Gerrit Code Review 8 months ago

Patch set 11 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/86888

Actions
Copy link
 #8

Updated by Benjamin Franzke 8 months ago

  • Tracker changed from Task to Feature
  • TYPO3 Version deleted (14)
Actions
Copy link
 #9

Updated by Gerrit Code Review 8 months ago

Patch set 12 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/86888

Actions
Copy link
 #10

Updated by Gerrit Code Review 8 months ago

Patch set 13 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/86888

Actions
Copy link
 #11

Updated by Gerrit Code Review 8 months ago

Patch set 14 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/86888

Actions
Copy link
 #12

Updated by Gerrit Code Review 7 months ago

Patch set 15 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/86888

Actions
Copy link
 #13

Updated by Gerrit Code Review 7 months ago

Patch set 16 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/86888

Actions
Copy link
 #14

Updated by Benjamin Franzke 7 months ago

  • Related to Task #105643: Transform all dates in DatabaseRowDateTimeFields to DateTime added
Actions
Copy link
 #15

Updated by Gerrit Code Review 7 months ago

Patch set 17 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/86888

Actions
Copy link
 #16

Updated by Gerrit Code Review 7 months ago

Patch set 18 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/86888

Actions
Copy link
 #17

Updated by Benjamin Franzke 7 months ago

  • Related to Task #105661: Add functional DataHandler tests for type=datetime added
Actions
Copy link
 #18

Updated by Gerrit Code Review 7 months ago

Patch set 19 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/86888

Actions
Copy link
 #19

Updated by Gerrit Code Review 7 months ago

Patch set 20 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/86888

Actions
Copy link
 #20

Updated by Gerrit Code Review 7 months ago

Patch set 21 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/86888

Actions
Copy link
 #21

Updated by Gerrit Code Review 7 months ago

Patch set 22 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/86888

Actions
Copy link
 #22

Updated by Gerrit Code Review 6 months ago

Patch set 23 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/86888

Actions
Copy link
 #23

Updated by Gerrit Code Review 6 months ago

Patch set 24 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/86888

Actions
Copy link
 #24

Updated by Garvin Hicking 3 months ago

  • Related to Bug #106364: DatetimeElement stores format=time in seconds, while extbase interprets it as timezone-offset-mapped UTC timestamp, when php timezone is not UTC added
Actions
Copy link
 #25

Updated by Gerrit Code Review 3 months ago

Patch set 25 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/86888

Actions
Copy link
 #26

Updated by Gerrit Code Review 3 months ago

Patch set 26 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/86888

Actions
Copy link
 #27

Updated by Gerrit Code Review 3 months ago

Patch set 27 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/86888

Actions
Copy link
 #28

Updated by Gerrit Code Review 3 months ago

Patch set 28 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/86888

Actions
Copy link
 #29

Updated by Gerrit Code Review 3 months ago

Patch set 29 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/86888

Actions
Copy link
 #30

Updated by Gerrit Code Review 3 months ago

Patch set 30 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/86888

Actions
Copy link
 #31

Updated by Gerrit Code Review 3 months ago

Patch set 31 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/86888

Actions
Copy link
 #32

Updated by Gerrit Code Review 3 months ago

Patch set 32 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/86888

Actions
Copy link
 #33

Updated by Gerrit Code Review 3 months ago

Patch set 33 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/86888

Actions
Copy link
 #34

Updated by Gerrit Code Review 3 months ago

Patch set 34 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/86888

Actions
Copy link
 #35

Updated by Gerrit Code Review 3 months ago

Patch set 35 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/86888

Actions
Copy link
 #36

Updated by Gerrit Code Review 3 months ago

Patch set 36 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/86888

Actions
Copy link
 #37

Updated by Gerrit Code Review 3 months ago

Patch set 37 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/86888

Actions
Copy link
 #38

Updated by Gerrit Code Review 3 months ago

Patch set 38 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/86888

Actions
Copy link
 #39

Updated by Gerrit Code Review 3 months ago

Patch set 39 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/86888

Actions
Copy link
 #40

Updated by Benjamin Franzke 3 months ago

  • Parent task set to #77562
Actions
Copy link
 #41

Updated by Gerrit Code Review 3 months ago

Patch set 40 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/86888

Actions
Copy link
 #42

Updated by Benjamin Franzke 3 months ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
Actions
Copy link
 #43

Updated by Benjamin Franzke about 2 months ago

  • Related to Bug #106595: 1970-01-01 in tt_content.date field after translation with date field disabled for editors added
Actions
Copy link

Also available in: Atom PDF