TYPO3 Core

Regarding the handling of timezone issues I found the following information:

Since TYPO3 4.2 we changed the handling of timezone: client converts to
UTC before sending form data to server. Server converts from UTC to
server-timezone before storing into database.

Unfortunately the system does not what is stated above. The class.t3lib_tcemain.php gets a UTC value from the backendform and the javascript and substracts the timezone offset. This is logically wrong. The system must add the (positive or negative) timezone offset before storing the timestamp into the database.

On the other hand, when generating the form, the system in class.t3lib_tceforms.php must take the timestamp (which is in local timezone of the server) from the database and substract the timezone offset to send a UTC value to the backendform. Currently it doesn't.

Normally you will not notice this error. You will only note this error when you import external information into the database directly. The
(issue imported from #M12570)