select * from tb where convert(varchar(8),时间字段,112) = convert(varchar(8),dateadd(dd,-1,getdate()),112)
declare @d datetime=getdate(); select cast(dateadd(day,-1,cast(@d as date)) as datetime);
select * from t_Admin where date between convert(varchar(10),dateadd(day,-1,getdate()))+' 00:00:00' and convert(varchar(10),getdate())+' 00:00:00'
select * from t_Admin where date between convert(varchar(10),dateadd(day,-1,getdate()),120)+' 12:00:00' and convert(varchar(10),dateadd(day,-1,getdate()),120)+' 23:59:59'
select * from tb where convert(varchar(8),时间字段,112) = convert(varchar(8),dateadd(dd,-1,getdate()),112)
declare @d datetime=getdate();
select cast(dateadd(day,-1,cast(@d as date)) as datetime);
select * from t_Admin
where date between convert(varchar(10),dateadd(day,-1,getdate()))+' 00:00:00'
and convert(varchar(10),getdate())+' 00:00:00'
where date between convert(varchar(10),dateadd(day,-1,getdate()),120)+' 12:00:00'
and convert(varchar(10),dateadd(day,-1,getdate()),120)+' 23:59:59'