⚲

Project

General

Profile

Sign in

Home
Projects
Help

Search:

TYPO3 Core

TYPO3 Core

Overview
Activity
Roadmap
Issues
Repository

Custom queries

12 LTS
Accessibility
Dashboard issues
Easy tasks
Extbase Issues
FAL Issues
FAL Sprint 2023
Hierarchical Issues
Issues reported for v11
JavaScript issues
JavaScript Issues (w/o Epics/Stories)
Most wanted Bugfixes
Most wanted Features
My open issues
New & Unassigned
No feedback within 90 days
Open Bugs
Open issues of 10
Page Tree Regressions after 2020-07-28
Recently modified
Regressions
Stabilization Issues
Usability or UX

Watchers (9)

Česlav Przywara
Christoph Dörfel
Jacob Dreesen
Marc Hirdes
Markus Klein
Timo Webler
Tizian Schmidlin
Uwe Trotzek
Uwe Wiebach

Actions

Epic #77562

open

Misbehaviors with datetime values and timezones

Added by Oliver Hader over 7 years ago. Updated 3 months ago.

Status:

Accepted

Priority:

Could have

Assignee:

-

Category:

DataHandler aka TCEmain

Target version:

Candidate for patchlevel

Start date:

2012-05-17

Due date:

% Done:

73%

Estimated time:

(Total: 0.00 h)

Sprint Focus:

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

Files

Download all files

TYPO3 datetime evaluation.pdf (361 KB) TYPO3 datetime evaluation.pdf		Markus Klein, 2017-06-06 18:20
TYPO3 datetime evaluation.pdf (367 KB) TYPO3 datetime evaluation.pdf		Markus Klein, 2017-06-07 14:12
datetimetest.zip (11.4 KB) datetimetest.zip	Test extension	Markus Klein, 2017-06-08 02:40

Subtasks 26 (7 open — 19 closed)

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

Closed

2012-05-17

Bug #68651: Datetime() properties have wrong timezone

Accepted

2015-07-30

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

New

2014-08-21

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

New

2014-12-01

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

Closed

2015-01-20

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

Closed

2015-04-15

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

Closed

2015-05-05

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

Closed

2015-08-24

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

Closed

2015-12-04

Bug #73637: Extbase DateTimeConverter cannot handle negative timestamps

Closed

2016-02-23

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

Closed

2016-08-21

Bug #78251: Not possible to output DateTime by TS

Rejected

2016-10-12

Task #78471: Acceptance test for Datepicker

Closed

2016-10-27

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

Closed

2017-01-08

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

Closed

2017-01-10

Bug #79304: SQL error if empty datetime value is saved

Closed

2017-01-12

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

Closed

2017-01-24

Bug #79557: Date fields DataMapper handling problem

New

2017-01-30

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

New

2017-02-03

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

New

2017-03-20

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

Closed

2017-05-15

Bug #81719: DateTime comparisons not possible in 8.7

Closed

2017-06-27

Bug #81940: FE_USER Access Stop Date

Closed

2017-07-21

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

Closed

2017-08-17

Bug #91240: Extbase DateTime with native dbType=datetime converts output differently

Closed

2020-04-30

Bug #91508: It is not possible to save "negative" dates, e.g. a year before jesus christus with date inputs

New

2020-05-27

Related issues 3 (1 open — 2 closed)

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

Closed

2018-07-20

Has duplicate TYPO3 Core - Bug #81489: Major time and date handling issues in BE

Closed

2017-01-12

Issue # Delay: days Cancel

History
Notes
Property changes

Actions

#1

Updated by Mona Muzaffar about 7 years ago

Related to Epic #80852: Datetime handling in backend added

Actions

#2

Updated by Markus Klein almost 7 years ago

Has duplicate Bug #81489: Major time and date handling issues in BE added

Actions

#3

Updated by Markus Klein almost 7 years ago

File TYPO3 datetime evaluation.pdf TYPO3 datetime evaluation.pdf added

Actions

#4

Updated by Markus Klein almost 7 years ago

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

Actions

#5

Updated by Markus Klein almost 7 years ago

Description updated (diff)

Actions

#6

Updated by Riccardo De Contardi almost 7 years ago

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

Actions

#7

Updated by Riccardo De Contardi almost 7 years ago

Tracker changed from Bug to Epic

Actions

#8

Updated by Markus Klein almost 7 years ago

File TYPO3 datetime evaluation.pdf 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

Actions

#9

Updated by Markus Klein almost 7 years ago

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

Actions

#10

Updated by Markus Klein almost 7 years ago

File deleted (~~datetimetest.zip~~)

Actions

#11

Updated by Markus Klein almost 7 years ago

File datetimetest.zip datetimetest.zip added

Actions

#12

Updated by Susanne Moog over 6 years ago

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

Actions

#13

Updated by David Bruchmann almost 6 years ago

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

Actions

#14

Updated by Benni Mack about 5 years ago

Category changed from Miscellaneous to DataHandler aka TCEmain

Actions

#15

Updated by Benni Mack about 5 years ago

Target version changed from next-patchlevel to Candidate for patchlevel

Actions

#16

Updated by Christoph Dörfel about 5 years ago

Since you're updating bug tickets where some of them are already over 3 years old (https://forge.typo3.org/issues/68651) and finally consider tackling this issue, maybe it would be worth looking at all the issues with dates and time zones, especially when saving dates for future events:
https://codeblog.jonskeet.uk/2019/03/27/storing-utc-is-not-a-silver-bullet/
This article is for C# but explains that it might not be enough to just save an ISO 8601 representation of the datetime. Time zone rules can change over time and existing dates in the future have to be updated accordingly. Just FYI.

Actions

#17

Updated by Susanne Moog about 5 years ago

Thanks for the comment and the link. Basically we are lacking the people to tackle this issue in a broad scope currently (afaik) - if you want to get involved (or know of people interested in helping out) please feel free to join #typo3-cms-coredev on slack - else I'm not seeing any quick fixes on this topic at this point in time.

Actions

#18

Updated by Benni Mack 11 months ago

Sprint Focus deleted (~~Stabilization Sprint~~)

Actions

Also available in: Atom PDF

Powered by Redmine © 2006-2024 Jean-Philippe Lang

Loading...

TYPO3: Legal Notice | Privacy Policy | Code of Conduct