Date Time MySQL

  1. Home
  2. MySQL
  3. Date Time
  4. Date and Time Column Types
Type                 Description
 
DATETIME             YYYY-MM-DD HH:MM:SS from 1000-01-01 00:00:00 to 9999-12-31 23:59:59 
 
DATE                 YYYY-MM-DD from 1000-01-01 to 9999-12-31 
 
TIMESTAMP            YYYYMMDDHHMMSS 
 
TIME                 HH:MM:SS 
 
YEAR                 YYYY