[TYPO3-50-general] Dates outside Unix Timestamp

Karsten Dambekalns karsten at typo3.org
Thu Dec 13 15:09:29 CET 2007


Alban Cousinié wrote:
>> the most obvious thing for me would be, to use date features of 
>> databases, or at least store the dates in that format 'yyyy-mm-dd'. 
>> Searching for specific dates or maybe birthdays is no big deal with this 
>> format.
> MySQL 5.0 documentation states :
> MySQL retrieves and displays DATETIME values in 'YYYY-MM-DD HH:MM:SS'
> format. The supported range is '1000-01-01 00:00:00' to '9999-12-31
> 23:59:59'.

Aside from dates outside that range that format is missing timezone 
information. So someone adds such a date in New York, and then it is to 
be displayed to someone in Paris. What happens?

Date/time handling is in no way a trivial task...


More information about the TYPO3-project-5_0-general mailing list