Date and Time Sizes, Formats, and Ranges : Date Type : Date Time SQL / MySQL

SQL / MySQL » Date Time » Date Type »

Date and Time Sizes, Formats, and Ranges



+---------+-----+--------------------+----------------+-----------------+
|Type     |Bytes|Format              |Start Date      |End Date         |
+---------+-----+--------------------+----------------+-----------------+
|DATE     |3    |YYYY-MM-DD          |1000-01-01      |9999-12-31       |
+---------+-----+--------------------+----------------+-----------------+
|DATETIME |8    |YYYY-MM-DD HH:MM:SS |1000-01-01      |9999-12-31       |
|and      |     |                    |00:00:00        |23:59:59         |
|TIMESTAMP|     |                    |                |                 |
+---------+-----+--------------------+----------------+-----------------+