[TYPO3-dev] conditional TCA changes

[Torsten Schrade]

Hi Xavier,

> Hi Dirk,
> 
>> Just to state it clear: this is not tx_news' fault but a result of the
>> handling of DateTime values by unix timestamps.
> 
> TYPO3 is able to handle dates as SQL dates with special TCA markup since
> 6.0, perhaps something worth investigating in your case:
> 
> http://xavier.perseguers.ch/en/tutorials/typo3/articles/native-date-type.html
> 
> HTH

Very good post and true. However, there is one limitation on the MySQL 
side when dealing with historical dates. Currently it just supports 
dates between 1000-01-01 and 9999-12-31. [1] No chance for the early 
middle ages, not to speak of antiquity... ;)

Best,
Torsten

[1] http://dev.mysql.com/doc/refman/5.0/en/date-and-time-type-overview.html