用SQL语句怎么获取当前日期的前一天???

[lemontreelau]

select *
from ...
where DateTime=当前日期的前一天.... ,这个条件要怎么写???

[zxkid]

SQL Server:
select * from TableName where DateDiff(day, DatetimeColumn, getdate()) = -1;

如果指定的日期字段不储存时间的话,还可以
select * from TableName where DatetimeColumn = DateAdd(day, -1, getdate());

[zxkid]

select * from TableName where DatetimeColumn = DateAdd(day, -1, getdate());


不好意思上面这句是错的,因为getdate()包括了时间

[lemontreelau]

那不包括时间怎么写呢?

[zxkid]

select * from TableName where DatetimeColumn = DateAdd(day, -1,
Convert(datetime, Convert(varchar(8), getdate(), 112), 112));

比较麻烦,建议你用DateDiff()

[dzhu_87]

select dateadd(day,1,getdate())

[dzhu_87]

select * from ...
where Datetime = dateadd(day,1,getdate())

[dzhu_87]

对不起，应该是：
select * from ...
where Datetime = dateadd(day,-1,getdate())

[sclml]

select *
from ...
where DateTime=getdate()-1

[diandian82]

mark

[kissknife]

select * from ...
where datediff(dd,yourcolumnname,getdate())=-1;

(SQL Server)

[Samen168]

mark

[myh0305]

select
sysdate -1
from testtable
group by sysdate;

[viena]

getdate()-1