What are the date fields in mysql

The date fields in mysql are: 1. DATE; 2. TIME; 3. YEAR; 4. DATETIME; 5. TIMESTAMP. Among them, the TIMESTAMP type has a proprietary automatic update feature.

mysql date and time type

(Recommended tutorial: mysql tutorial)

mysql has There are 5 date and time types representing time values, namely, DATE, TIME, YEAR, DATETIME, and TIMESTAMP.

Among them, the TIMESTAMP type has a proprietary automatic update feature.

Look at the table below:

Related recommendations: php training

The above is the detailed content of What are the date fields in mysql. For more information, please follow other related articles on the PHP Chinese website!