MySQL uses the Date_format method to achieve statistics daily/monthly new users

To implement statistics for new users daily or monthly, but the time that is stored in the database is a timestamp, so use the Date_format function

Data for database table storage:

To count the new users of the day, format the timestamp format as an adult-month-day form and group by the field in Format (group by), counting the Count

SQL statements:

SELECT date_format (create_time, '%y-%m-%d ') as time, COUNT (*) as Count from Tb_users GROUP by Time  

Query Result:

Specific usage of Date_format

Http://www.w3school.com.cn/sql/func_date_format.asp

MySQL uses the Date_format method to achieve statistics daily/monthly new users