34,594
社区成员
发帖
与我相关
我的任务
分享
select
convert(varchar(10),addtime,120),count(1)
from
tb
where
datediff(dd,addtime,getdate())>=0
group by
convert(varchar(10),addtime,120)
select
convert(varchar(10),addtime,120),count(1)
from
tb
group by
convert(varchar(10),addtime,120)
select convert(varchar(10),addtime,120),count(*)
from tb
group by convert(varchar(10),addtime,120)
select count(1) from tb where datediff(dd,addtime,getdate())=0