mysql查询指定时间范围的数据

大大源码 • 2023年4月5日 am8:28 • 其他

查询当天数据

select count(1) from crm_cust_info where user_id = '85e20499438e6f0c7296a68530aea53a' and to_days(create_date) = to_days(now()) and cust_source = 2

查询指定天数前的数据

select count(1) from crm_cust_info where user_id = '85e20499438e6f0c7296a68530aea53a' and  to_days(now())-to_days(create_date) = 1 and cust_source = 2

查询一周内的数据

select count(1) from crm_cust_info where user_id = '85e20499438e6f0c7296a68530aea53a' and YEARWEEK(date_format(create_date,'%Y-%m-%d')) = YEARWEEK(now()) and cust_source = 2

查询一个月内的数据

select count(1) from crm_cust_info where user_id = '85e20499438e6f0c7296a68530aea53a' and date_format(create_date,'%Y-%m') = DATE_FORMAT(CURDATE(),'%Y-%m' ) and cust_source = 2

原文链接：https://blog.csdn.net/qq_56042039/article/details/128683833

THE END

大大搜源码

搜索内容

mysql查询指定时间范围的数据