[TYPO3-core] RFC: #12652: Value Preview of empty timestamp shows "01-01-70 (-40 yrs) "

Dmitry Dulepov dmitry.dulepov at gmail.com
Mon Dec 7 11:50:52 CET 2009


On 23/11/2009 19:01, David Bruchmann wrote:
> So the default value of those fields should be NULL instead of '0', that
> should clear all the problems with the date in future. Old databases
> have to be updated but afterwards 0 could be used without any problems.

I do not really like the idea because it will create more complex SQL queries. They are far from fast&optimal now and they will become even slower because of extra conditions.

If we want to do it properly, we should change all date/time fields from int to datetime and use those. Then we can assign proper defaults (such as '0000-00-00' and '2099-12-31' and do very simple checks in SQL.

Dmitry Dulepov
"Trust me, I am a doctor!" (c) Gregory House, M.D.

More information about the TYPO3-team-core mailing list