Mysql groups the field time by day/month/year _ MySQL

The time field in the table is in the Unix timestamp format. you need to calculate the number of records per day based on this field and group the records by day, month, and year. assume that the table has a field time in the format of Unix timestamp, calculate the number of records per day based on this field.

Method:

Use the convert function convert (char (10), time, 120) as time, and then group by time.

Principle: The convert function converts the timestamp to the ODBC standard time (specified by the 120 parameter), takes the first 10 digits, and obtains the complete date (excluding the time, minute, and second), and then groups it.

The duration of the first parameter of the convert () method is the same as that of the yearly grouping method.