[TYPO3-dev] stdwrap->strftime and timezone

Martin Kutschker martin.kutschker-n0spam at no5pam-blackbox.net
Sat Apr 1 23:50:02 CEST 2006


Franz Koch schrieb:
> 
> 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 ;)

So what? You're right that this problem should be solved, but really is 
wholly unrelated.

> 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.

No as TYPO3 should not rely on completely unportable Mysql features. 
Maybe DBAL is powerful enough to handle date field cross-DB wise, but if 
not another solution must be used. I still favour Julian dates.

Masi




More information about the TYPO3-dev mailing list