#68579TCA field of type time saves different data in database
Description
In 6.2 a field of type “time” stored the number of seconds for a given time.
12:30 was stored as "45000"
One could use the \TYPO3\CMS\Backend\Utility\BackendUtility::time() method to render the time.
Currently the specified time is stored as seconds “on the current day”, which kills any business logic expecting the original values.
12:30 is now stored as "1438086600"
I’m not sure if this was introduced with 7.3 or even earlier
After fixing this bug, we need an upgrade wizard to fix all time fields in DB which contain values > 86399.
TCA:
'timefrom' => array(
'exclude' => 0,
'label' => 'time from',
'config' => array(
'type' => 'input',
'size' => '30',
'eval' => 'required,time',
)
),