[TYPO3-50-general] Dates outside Unix Timestamp
Karsten Dambekalns
karsten at typo3.org
Thu Dec 13 15:09:29 CET 2007
Hi.
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...
Kartsen
More information about the TYPO3-project-5_0-general
mailing list