Actions
Bug #18956
closed
It's not possible to save dates prior to 1970 in the database.
Status:
Closed
Priority:
Should have
Assignee:
-
Category:
-
Target version:
-
Start date:
2008-06-13
Due date:
% Done:
0%
Estimated time:
TYPO3 Version:
4.2
PHP Version:
5.1
Tags:
Complexity:
Is Regression:
Sprint Focus:
Description
It's not possible to save dates prior to 1970 in the database, because all date fields is defined as "unsigned"
In order to fix the problem, all date fields in typo3/sysext/cms/ext_table.sql should be changed from "unsigned" to "signed"
(issue imported from #M8709)
Updated by Benni Mack over 16 years ago
hey Peter,
well, I had the birthdate field in an extension and it worked fine with dates before 1970.
However, it always depends on the fields and if it is needed. "endtime" does not need to be unsigned, don't you think?
Which fields do you mean exactly?
Updated by Peter Klein over 16 years ago
I guess I was a bit quick in reporting this, as there's really no need to have dates prior to 1970 in the core setup, other than birthday fields, like the one in FE users. And that one is already signed.
Sorry.
Actions