怎样写［今日更新］这个SQL语句！！

[netvsj2ee]

时间字段 tim 类型为smalldatetime,统计出今日更新多少软件
谢谢大家,请帮忙!

[orcale]

select count(*) from table where datediff(day,tim,getdate())=0

[yujohny]

select count(*) from 表
where convert(varchar(10),tim,120)=convert(varchar(10),getdate(),120)

[sdhdy]

select count(*) from table where datediff(dd,tim,getdate())=0

[txlicenhe]

Select count(*) from tableName
where datediff(day,tim,getdate()) = 0

[netvsj2ee]

楼上的四位都对,忠心感谢!!