select getdate()-1
SELECT DATEADD(DAY, -1, GETDATE())
或者用DateDiff函数
select convert(varchar(10),getdate()-1,120)
select getdate()-1
SELECT DATEADD(DAY, -1, GETDATE())
或者用DateDiff函数
select convert(varchar(10),getdate()-1,120)
转载于:https://www.cnblogs.com/tomkillua/archive/2009/04/14/1435730.html