Date Time MySQL

  1. Home
  2. MySQL
  3. Date Time
  4. 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