摘要:
查询60天内的数据 SELECT * FROM 表 WHERE TO_DAYS(NOW())-TO_DAYS(create_time)<=60AND deleted=0 阅读全文
摘要:
按照季度统计 SELECT CONCAT(DATE_FORMAT(create_time, '%Y'),'-',FLOOR((DATE_FORMAT(create_time, '%m')+2)/3),'季度') AS QUARTER ,COUNT(1) AS 总量 FROM 表 WHERE crea 阅读全文