Mega Code Archive

 

Categories / MySQL / Date Time

 

The datetime data types

Data type         Format                             Range DATE              YYYY-MM-DD                         1000-01-01 through 9999 TIME              HH:MM:SS                           -838:59:59 to 838:59:59 DATETIME          YYYY-MM-DD HH:MM:SS                1000-01-01 00:00:00 through 9999 YEAR              YYYY                               1901 to 2155 (and 0000) TIMESTAMP         YYYY-MM-DD HH:MM:SS                1970-01-01 00:00:00 to partway through 2037