MySQL range query (date)

MySQL Time and date type

Data type	Number of bytes	Data format
Year	1	YYYY
Date	4	Yyyy-mm-dd
Time	3	HH:MM:SS
Datetime	8	YYYY-MM-DD HH:MM:SS
Timestamp	4	YYYY-MM-DD HH:MM:SS

It is important to note that if the insert data is not valid, the system will automatically insert the corresponding 0 value into the database.

Structure of the query table (for example, in Date type ), as follows

Querying the contents of a table

Between keyword query time, date range

where keyword compare query time, date range

MySQL range query (date)