Home >Database >Mysql Tutorial >What are the date fields in mysql
What are the date fields in mysql
- 王林Original
- 2020-09-30 10:29:095397browse
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!
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：How to open mysql in wampNext article：How to open mysql in wamp