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

This article uses easy-to-understand examples to introduce what format mysql time uses, the content is very detailed, interested friends can refer to it, I hope it can be helpful to you.

What is the format of mysql time?

There are three data types for storing dates in Mysql

1.Date data type: used to store dates that have no time. Mysql acquires and displays this type in YYYY-MM-DD, with a supported time range of 1000-00-00 to 9999-12-31.

2.Datetime type: stores data with both dates and times. The format for storage and display is YYYY-MM-DD HH:MM:SS, and the supported time range is 1000-00-00 00:00:00 to 9999-12-31 23:59:59.

3.Timestamp type: also stores data with both dates and times. The format for storage and display is the same as Datetime, with a supported time range from 1970-01-01 00:00:01 to 2038-01-19 03:14:07.

MySQL is a relational database management system developed by the Swedish company MySQL AB and belongs to the products of Oracle. MySQL is one of the most popular relational database management systems. In the aspect of WEB application, MySQL is one of the best RDBMS (Relational Database Management System) application software. MySQL is a relational database management system in which relational databases store data in different tables instead of all data in one large warehouse, which increases speed and flexibility.

About mysql time with what format to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can 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.