The SQL standard permits three types. DATE, TIME and TIMESTAMP.
A TIMESTAMP includes a date and a time.|
Several engines use the word TIMESTAMP for a different purpose.
|Specific to MySQL|
|Use DATETIME in place of TIMESTAMP. TIMESTAMP may be used as a column type - but it means something totally different - it encourages "automatic marking" of insert or updates. MySQL Manual|