Epic #77562

Misbehaviors with datetime values and timezones

Added by Oliver Hader over 2 years ago. Updated 5 months ago.

Status:
Accepted
Priority:
Could have
Assignee:
-
Category:
Miscellaneous
Target version:
Start date:
2012-05-17
Due date:
% Done:

54%

Sprint Focus:
Stabilization Sprint

Description

This issue serves as an umbrella collector.

We can do little to fix stuff in v7, but we shall fix a lot in v8.

The goals for v8 are:

  • Same DB content as in v7
  • Values written to FormEngine must contain the server's timezone in the ISO-format
  • FormEngine JS must be aware of the timezone used in BE to write back correct values

TYPO3 datetime evaluation.pdf (361 KB) Markus Klein, 2017-06-06 18:20

TYPO3 datetime evaluation.pdf (367 KB) Markus Klein, 2017-06-07 14:12

datetimetest.zip - Test extension (11.4 KB) Markus Klein, 2017-06-08 02:40


Subtasks

Bug #37244: TCA date evaluation for dates lower 01-01-1970 failsAcceptedMathias Schreiber

Bug #68651: Datetime() properties have wrong timezoneAcceptedAndreas Wolf

Feature #61110: Support for timezones in all date fields in TYPO3 BENew

Bug #63482: Query constraint on a DateTime field with a DateTime argument should trigger date formatNew

Feature #64372: Add timezone-handling for value-display depending on FE-userNew

Bug #66435: Scheduler Task - Cron Command for recurring tasks not evaluated correctlyClosed

Bug #66793: "simulate time" in admin-panel does not respect timezoneClosed

Bug #69290: Dates get reduced by a day if before 1970Closed

Feature #72053: Extbase: Support \DateTimeInterface instead of \DateTimeResolved

Bug #73637: Extbase DateTimeConverter cannot handle negative timestampsNew

Bug #77563: Native DBMS datetime columns are not handled correctlyClosed

Bug #78251: Not possible to output DateTime by TSRejected

Task #78471: Acceptance test for DatepickerClosedDaniel Lorenz

Bug #79197: There should be ISO Date Format Year-Month-DayClosedMarkus Klein

Bug #79249: TCA fields with eval types "time" or "timesec" are incorrectly stored in the databaseClosedMarkus Klein

Bug #79304: SQL error if empty datetime value is savedClosedSascha Egerer

Bug #79448: Handling dates in the very past inside T3-BackendNew

Bug #79557: Date fields DataMapper handling problemNew

Bug #79613: Saving wrong Date into DB if Field is of type DATENew

Bug #80349: Extbase mapping of \DateTime for integer values does not set timezone with region string but only offsetNew

Bug #81228: l10n_mode exclude doesn't work correctly for timestamp fieldsClosed

Bug #81719: DateTime comparisons not possible in 8.7Under Review

Bug #81940: FE_USER Access Stop DateClosed

Bug #82126: EXT:belog - Error when using a custom timeframe Closed


Related issues

Related to TYPO3 Core - Feature #51844: Fix date-format in edit-view of a record Accepted 2013-09-09
Related to TYPO3 Core - Bug #85602: The date and time are wrong in the log module view New 2018-07-20
Duplicated by TYPO3 Core - Bug #81489: Major time and date handling issues in BE Closed 2017-01-12

History

#1 Updated by Mona Muzaffar almost 2 years ago

  • Related to Epic #80852: Datetime handling in backend added

#2 Updated by Markus Klein almost 2 years ago

  • Duplicated by Bug #81489: Major time and date handling issues in BE added

#4 Updated by Markus Klein almost 2 years ago

  • Description updated (diff)
  • Status changed from New to Accepted
  • Complexity set to medium

#5 Updated by Markus Klein almost 2 years ago

  • Description updated (diff)

#6 Updated by Riccardo De Contardi almost 2 years ago

  • Related to deleted (Epic #80852: Datetime handling in backend)

#7 Updated by Riccardo De Contardi almost 2 years ago

  • Tracker changed from Bug to Epic

#8 Updated by Markus Klein almost 2 years ago

  • File TYPO3 datetime evaluation.pdf added
  • File datetimetest.zip added
  • Tracker changed from Epic to Bug
  • TYPO3 Version set to 7
  • PHP Version set to 5.5
  • Complexity set to medium
  • Is Regression set to No

#9 Updated by Markus Klein almost 2 years ago

  • Tracker changed from Bug to Epic
  • Target version set to next-patchlevel
  • Sprint Focus set to Stabilization Sprint

#10 Updated by Markus Klein almost 2 years ago

  • File deleted (datetimetest.zip)

#11 Updated by Markus Klein almost 2 years ago

#12 Updated by Susanne Moog about 1 year ago

  • Related to Feature #51844: Fix date-format in edit-view of a record added

#13 Updated by David Bruchmann 8 months ago

  • Related to Bug #85602: The date and time are wrong in the log module view added

Also available in: Atom PDF