数据库表示今年,本月,今天示例语句及函数

今年:

SELECT userphone ,count(intime) times from EXPRESS where YEAR(intime)=YEAR(CURDATE()) GROUP BY userphone ORDER BY times DESC;

本月:
SELECT userphone ,count(intime) times from EXPRESS where YEAR(intime)=YEAR(CURDATE()) GROUP BY userphone ORDER BY times DESC;

今天:
SELECT userphone ,count(intime) times from EXPRESS where DAY(intime)=DAY(CURDATE()) GROUP BY userphone ORDER BY times DESC;

或下面这个(今天)

SELECT COUNT(EXPRESSID) TOTALEXPRESS,COUNT*(TO_DAYS(INTIME)=TO_DAYS(NOW()) OR NULL)* TODAYNEWEXPRESS,COUNT(STATUS=0 OR NULL) TOTALREMAININGEXPRESS,COUNT(TO_DAYS(INTIME)=TO_DAYS(NOW()) AND STATUS=0 OR NULL) TODAYNEWREMAININGEXPRESS FROM EXPRESS ;