Date Data Types MySQL

MySQL may be the following data types for dates

DATE

The DATE data type for storing a date in the format YYYY-MM-DD (4 digit year, dash, 2 digits for the month, dash, 2 digits for the day).

DATETIME

The DATETIME data type for storing date and time, formatted as YYYY-MM-DD HH: MM: SS

TIMESTAMP

The TIMESTAMP data type is equivalent to the above type, DATETIME, YYYY-MM-DD HH: MM: SS

TIME

The TIME data type used to store the time in the format HH: MM: SS

YEAR

YEAR data type used to store the year in the format YYYY