SQLZOO, Date and time types.

Date and time types.

MySQL
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.	Run the tidy code silently CREATE TABLE t_dttest( a DATE, b TIME, c DATETIME); INSERT INTO t_dttest VALUES ( DATE '1962-05-20', TIME '10:32:16', TIMESTAMP '1962-05-20 10:32:16'); SELECT * FROM t_dttest;
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

SQLzoo.net