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

What is the date-time type of mysql? In view of this problem, this article introduces the corresponding analysis and answers in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible way.

What is the date and time type of mysql

There are three commonly used 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.

This is the answer to the question about what the date and time type of mysql is. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel to learn more about it.

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.