Actions
Bug #79249
closed
Epic #77562: Misbehaviors with datetime values and timezones
TCA fields with eval types "time" or "timesec" are incorrectly stored in the database
Status:
Closed
Priority:
Must have
Assignee:
Category:
DataHandler aka TCEmain
Target version:
Start date:
2017-01-10
Due date:
% Done:
100%
Estimated time:
TYPO3 Version:
8
PHP Version:
7.0
Tags:
Complexity:
Is Regression:
Yes
Sprint Focus:
Stabilization Sprint
Description
As mentioned in the title, TCA fields with eval value "time" or "timesec" are stored incorrectly to the database in TYPO3 8.5.1.
In my setup i will get the value "1484084700" in the database if i select 23:45 for the give field.
The documentation suggests that the value will just hold the seconds from 1970-01-01 00:00:00 to the selected time:
https://docs.typo3.org/typo3cms/TCAReference/Reference/Columns/Input/Index.html#eval
The display will be like "23:45" while the database will be "85500".
In TYPO3 8.4.1 this works as expected. It seems like the changes from #77702 have changed this behaviour.
Following code block is responsible for this issue:
(/typo3/sysext/core/Classes/DataHandling/DataHandler.php @Line #2693)
case 'time':
case 'timesec':
case 'date':
case 'datetime':
// a hyphen as first character indicates a negative timestamp
if ((strpos($value, '-') === false && strpos($value, ':') === false) || strpos($value, '-') === 0) {
$value = (int)$value;
} else {
// ISO 8601 dates
$dateTime = new \DateTime($value);
// The returned timestamp is always UTC
$value = $dateTime->getTimestamp();
}
// $value is a UTC timestamp here.
// The value will be stored in the server’s local timezone, but treated as UTC, so we brute force
// subtract the offset here. The offset is subtracted instead of added because the value is stored
// in the timezone, but interpreted as UTC, so if we switched the server to UTC, the correct
// value would be returned.
if ($value !== 0 && !$this->dontProcessTransformations) {
$value -= date('Z', $value);
}
break;
Updated by 
Updated by 
Updated by 
Updated by 
Updated by 
Updated by 
Updated by
Actions