CoolSlob() 的正确,但在数据多的时候,以下语句效率会高些:select * from news where NewsDate BETWEEN convert(datetime,(convert(char(8),GETDATE(),112))) AND DATEADD(day,1,convert(datetime,(convert(char(8),GETDATE(),112))))
select * from news where day(NewsDate)=day(Getdate())
where NewsDate BETWEEN convert(datetime,(convert(char(8),GETDATE(),112))) AND DATEADD(day,1,convert(datetime,(convert(char(8),GETDATE(),112))))