SELECT LEFT(CONVERT(VARCHAR(10),monitoringtime, 120), 7) AS time, COUNT(*) AS num FROM t_web_pre_securitybug WHERE monitoringtime BETWEEN '2015-01-01' AND '2015-12-31' GROUP BY LEFT(CONVERT(VARCHAR(10), monitoringtime, 120), 7)
转载于:https://my.oschina.net/u/2260184/blog/535971