[TYPO3-dev] stdwrap->strftime and timezone

[Franz Koch]

Hi,
> Issues I see:
> - How does/should a servers timezone affect the storage of timestamps  
> in TYPO3?
> - When should those dates be converted during display?
> - How does  the timezone of an editor affect the date he submits?  
> Especially because on the client browser of the editor the date he  
> enters (assuming he is in his own timezone) gets converted to unix- time 
> seconds - but wouldn't that be false on a server in another  timezone?
> 
> Somehow it sounds very much like charset issues, but I'm not sure.

by working on this issue, maybe the problem with dates before 1970 
(birthdays etc.) could be taken in charge as well. I know that it has 
nothing to do with timestamps, but at least it is date related ;)

MySQL has a special date storage-type as much as I know (I'm no MySQL 
guru) in the format 'YYYY-MM-DD'? and special functions for searching, 
selecting etc. Maybe pure date inputfields in TCE should also be stored 
in this format and not be converted to a timestamp. Would at least be 
nice for future versions of typo3.

-- 
Kind regards,
Franz Koch