查询前一天数据

select * from  表 where datediff(dd,cast(日期字段 as datetime),getdate()) <=1

?