sql:按年、月、日钻取时间
#成功按月排
SELECT count(EN_NAME), DATE_FORMAT( CREATE_DATE, "%Y-%m" )
FROM finance
WHERE DATE_FORMAT( CREATE_DATE, "%Y" ) = "2016"
GROUP BY DATE_FORMAT( CREATE_DATE, "%Y-%m" )
#成功按日排
SELECT count(EN_NAME), DATE_FORMAT( CREATE_DATE, "%Y-%m-%d" )
FROM finance
WHERE DATE_FORMAT( CREATE_DATE, "%Y" ) = "2016"
GROUP BY DATE_FORMAT( CREATE_DATE, "%Y-%m-%d" )
更多精彩
