1、
select * from ta where datediff(day,FA,getdate())=02、
select CONVERT(varchar(10),FA,120),count(*) from ta group by CONVERT(varchar(10),FA,120)
select * from ta where datediff(day,FA,getdate())=02、
select CONVERT(varchar(10),FA,120),count(*) from ta group by CONVERT(varchar(10),FA,120)
select * from TA where datediff(dd,FA,getdate())=0或
2.用convert方法将日期转换成只保留年月日的格式再进行比较select * from TA where convert(varchar,FA,102)=convert(varchar,getdate(),102)
select convert(varchar,FA,102) as FA,sum(要汇总的字段) as 合计 from TA
group by convert(varchar,FA,102)