推荐订阅源

Code

select convert(nvarchar(13),begintime,120),count(1) from tb_table(nolock)
where begintime>='2008-10-20' and begintime<'2008-10-21'

group by convert(nvarchar(13),begintime,120)