Shulou(Shulou.com)06/01 Report--

This article will explain in detail what MySQL date and time data types are, Xiaobian thinks it is quite practical, so share it with you as a reference, I hope you can gain something after reading this article.

MySQL Date Time Data Type

1. Date and date

datetime Format: Year-Month-Day Hours: Minutes: Seconds Support Range 1000-01-01 00:00:00 to 9999-12-31 23:59:59

2. timestamp timestamp

datetime and timestamp types behave the same, with the following differences:

datetime from 1-9999, timestamp from 1970 - 2038 (because timestamp takes up 4 bytes, just like integer range, the number of seconds after January 19, 2038 11:14:07 exceeds 4 bytes)

3. year

It can only represent the years between 1901 and 2155, because it only takes up 1 byte and can only represent 255 numbers.

4. time

Can represent time or interval, range-838: 59:59-838:59:59

About "MySQL date and time data types what" this article is shared here, I hope the above content can be of some help to everyone, so that you can learn more knowledge, if you think the article is good, please share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.