-- 前一天 SELECT * FROM [ tb ] WHERE [ 日期字段 ] BETWEEN DATEADD ( DAY , - 1 , CONVERT ( VARCHAR ( 8 ), GETDATE