#61110Support for timezones in all date fields in TYPO3 BE
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
> * http://forge.typo3.org/issues/27919 Preview in Admin Panel does not handle Timezone correctly
> * http://forge.typo3.org/issues/32081 document timezone handling / eval datetime
> * http://forge.typo3.org/issues/20088 In BE time and datetime fields GMT-0 will be shown by ja
Reviews 1
Fix this issue
Start the commit message of your patch with this. Add what the patch does, and the versions it goes to in "Releases:". The changes above were merged or abandoned: read them before you start. How to create a patch
- Commit message
-
[FEATURE] Support for timezones in all date fields in TYPO3 BE Resolves: #61110 Releases: main
Related issues 20
- Bug #20088In BE time and datetime fields GMT-0 will be shown by javascript, but GMT+1 will be saved
- Bug #21466Deprecate serverTimezone
- Bug #21838Date field on TCA can't accept 1-1-1970 as
- Bug #27919Preview in Admin Panel does not handle Timezone correctly
- Feature #32081document timezone handling / eval datetime
- Bug #37244TCA date evaluation for dates lower 01-01-1970 fails
- Bug #51918Native date and datetime values do not consider timezone
- Bug #53640js validation for datetime + required doesn't work for below 1970
- Task #59472Backend date format
- Bug #61952bug dbType for date before 01-01-1970
- Feature #64372Add timezone-handling for value-display depending on FE-user
- Bug #64953dbType date and datetime fields are saved in wrong timezone
- Bug #69290Dates get reduced by a day if before 1970
- Bug #72878wrong datetime handling, they are not UTC in db
- Bug #92391DateTime property has wrong TimeZone in Backend List view
- Bug #96890Wrong processing and display of native datetime(dbType) fields due to server timezone
- Bug #100462Task execution time changed when timezone "Europe/Zurich" (or timezone with time change in spring)
- Bug #101171EXT:belog ignores timezone in filter
- Bug #102087Backend user need a own timezone
- Task #104309Use ISO dates in FormEngine date handling