MySQL Build database datetime, DATE, and timestamp differences

Http://blog.sina.com.cn/s/blog_5f7b8c2c0100tf6t.html DATETIME、 DATEand TIMESTAMP  the type are similar. This article describes their characteristics and their similarities and differences.

DATETIMEThe type can be used for values that need to contain both date and time information.

MySQL to   ' yyyy-mm-dd HH:MM:SS '   to   ' 9999-12-31 23:59:59 ' . (The meaning of "support" is that although earlier values may work, there is no guarantee that they can.) )

DATEThe type can be used when a date value is required instead of the time portion. MySQL ‘YYYY-MM-DD‘ retrieves and displays values in a format DATE . The scope of support is ‘1000-01-01‘ to ‘9999-12-31‘ .

TIMESTAMPThe column type provides a type through which you can automatically mark Insert or Update manipulate the date and time of the current operation . If there are multiple columns in a table TIMESTAMP , only the first one is automatically updated.