匹配个格式:年-月
2012-8
where convert(varchar(7),starttime,120)='" + 2012-8+ "'"
年月日 时间匹配
2013-01-09 17:48:57.387 与 2013-01-09 00:00:00.000 不相等 2013-01-09 17:48:57.387 !=2013-01-09 00:00:00.000
2013-01-09 00:00:00.000 与2013-01-09 相等 2013-01-09 00:00:00.000=2013-01-09