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

This article mainly introduces the summary of data types on the date represented by MySQL, which has certain reference value and can be used for reference by friends who need it. Let's take a look at the simple ways to hide files under Linux.

MySQL represents the data type of the date

Type name date format date range storage requirements YEARYYYY1901 ~ 21551 bytes TIMEHH:MM:SS-838:59:59 ~ 838 DATEYYYY-MM-DD1000 5915 DATEYYYY-MM-DD1000-01-01 ~ 9999-12-33 bytes DATETIMEYYYY-MM-DD HH:MM:SS1000-01-01 00:00:00 ~ 9999-12-31 23 DATEYYYY-MM-DD1000 59 DATEYYYY-MM-DD1000 598 bytes TIMESTAMPYYYY-MM-DD HH:MM:SS1980-01-01 00:00:01 UTC ~ 2040-01-19 03:14:07 UTC4

These are the details of the summary of the data types of the date represented by MySQL. Have you learned anything after reading it? If you want to know more about it, welcome to the industry information!

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.