TSQL选择以前日期的记录-TSQLSELECTpreviousdate'srecords

1  

This example assumes SQL Server:

本例假设SQL Server:

select *
from log
where convert(varchar(8), DateAndTime , 112)  = convert(varchar(8), getdate()-1, 112)

Essentially, convert the date to yyyymmdd (the 112 parameter) and then check it is equal to yesterday's date (getdate()-1), also converted to yyyymmdd.

本质上，将日期转换为yyyyymmdd(112个参数)，然后检查它是否等于昨天的日期(getdate()-1)，也转换为yyyyyyymmdd。

0  

Assuming SQL Server

如果SQL Server

 declare @today date
 set @today = GETDATE()

 select * from Log where DateAndTime between DATEADD(dd, -1, @today ) and @today

0  

It should include conditional operator and not between . Otherwise it includes today's records as well.

它应该包含条件运算符，而不是中间的。除此之外，它还包括今天的记录。

Declare @today date
Set @today = GETDATE()


Select YourcolumnNames from log
Where DateAndTime >= DATEADD(dd, -1, @today ) and DateAndTime