Feature #61110

Epic #77562: Misbehaviors with datetime values and timezones

Support for timezones in all date fields in TYPO3 BE

Added by Nikola Stojiljković about 7 years ago. Updated about 3 years ago.

Status:
New
Priority:
Should have
Assignee:
-
Category:
FormEngine aka TCEforms
Start date:
2014-08-21
Due date:
% Done:

0%

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

Description

Johannes Feustel:

As an editor and as a dev
i want a documentation about how datetime filed acutally behave in typo3
so that i understand what values (TZ) to enter and how to test

AC
there should be a document/wiki page listing all relevant datetime fields like
  • access stop start of content and pages and records
  • admin panel
  • scheduler task
  • publish date for workspaces

Define meaningful use cases covering each of those like:
beeing in a specific timezone like CEST while server is in PST, entering a datetime into start field of a page
what will be save to the db? local time? server time?
when will it go live acutally?
How to test? what do i need to emter into the mock date filed of the admin panel (server time?)?

Description

All time fields in TYPO3 should be easy understandable (format) and lead to reliable result.
Format should ideally be based on a user setting and for all the places below TYPO3 should display the timezone

Following cases should be covered

  • admin panel
  • schedule for content desired for display in different timezone compared to server time
  • date time of a workspace to auto publish
  • parse datetime string possible like "today", "MM:HH DD-MM-YYYY", ISO 8601: "YYYY-MM-DD HH:MM", "Tue, 24 Nov 09 16:00:00 -0500" in the client?
  • make it possible for the editor to change format of datetime fields in user settings?
See also

Files

be_user_date_settings.png (85.2 KB) be_user_date_settings.png Nikola Stojiljković, 2014-08-25 22:18
sample_fields_with_timezone.png (28.1 KB) sample_fields_with_timezone.png Nikola Stojiljković, 2014-08-25 22:18
sample_fields_with_timezone.png (14.7 KB) sample_fields_with_timezone.png Nikola Stojiljković, 2014-08-25 22:20
be_user_date_settings.png (48.5 KB) be_user_date_settings.png Nikola Stojiljković, 2014-08-25 22:20
sample_kolkata.png (10.6 KB) sample_kolkata.png Nikola Stojiljković, 2014-08-26 11:18
sample_belgrade.png (11.6 KB) sample_belgrade.png Nikola Stojiljković, 2014-08-26 11:18
sample_chatam.png (10.6 KB) sample_chatam.png Nikola Stojiljković, 2014-08-26 11:22

Related issues

Related to TYPO3 Core - Bug #27919: Preview in Admin Panel does not handle Timezone correctlyClosed2011-07-06

Actions
Related to TYPO3 Core - Feature #32081: document timezone handling / eval datetimeNew2011-11-25

Actions
Related to TYPO3 Core - Bug #20088: In BE time and datetime fields GMT-0 will be shown by javascript, but GMT+1 will be savedRejectedErnesto Baschny2009-02-24

Actions
Related to TYPO3 Core - Bug #51918: Native date and datetime values do not consider timezoneClosed2013-09-11

Actions
Related to TYPO3 Core - Bug #21838: Date field on TCA can't accept 1-1-1970 asClosed2009-12-10

Actions
Related to TYPO3 Core - Bug #61952: bug dbType for date before 01-01-1970Closed2014-09-29

Actions
Related to TYPO3 Core - Bug #53640: js validation for datetime + required doesn't work for below 1970ClosedGeorg Ringer2013-11-14

Actions
Related to TYPO3 Core - Bug #37244: TCA date evaluation for dates lower 01-01-1970 failsClosed2012-05-17

Actions
Related to TYPO3 Core - Feature #64372: Add timezone-handling for value-display depending on FE-userNeeds Feedback2015-01-20

Actions
Related to TYPO3 Core - Bug #64953: dbType date and datetime fields are saved in wrong timezoneClosed2015-02-10

Actions
Related to TYPO3 Core - Bug #21466: Deprecate serverTimezoneClosedOliver Hader2009-11-05

Actions
Related to TYPO3 Core - Task #59472: Backend date formatClosed2014-06-11

Actions
Related to TYPO3 Core - Bug #69290: Dates get reduced by a day if before 1970Closed2015-08-24

Actions
Related to TYPO3 Core - Bug #72878: wrong datetime handling, they are not UTC in dbClosed2016-01-21

Actions
Has duplicate TYPO3 Core - Feature #80559: datetime and time handling should always have timezone informationClosed2017-03-29

Actions

Also available in: Atom PDF