[TYPO3-english] Difference empty dates and 1/1/70 date

Dmitry Dulepov dmitry at typo3.org
Thu Sep 16 08:39:14 CEST 2010


Hi!

Xavier Perseguers wrote:
> DATE/DATETIME datatype is supported by any decent DBMS. Timestamp are
> unfriendly when accessing the data directly (e.g, phpMyAdmin) and not
> being able to store a date < 1970 as of September 2010 seems really weird!

Yes, even SQL'92 defines DATETIME...

http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt

-- 
Dmitry Dulepov
TYPO3 core&security team member
Twitter: http://twitter.com/dmitryd
Read more @ http://dmitry-dulepov.com/


More information about the TYPO3-english mailing list