sql 日期常用函数

select dateadd(day,-1,convert(varchar(8),getdate(),112)) -- 2012-05-11 00:00:00.000
select convert(varchar(10),getdate(),120) -- 2012-05-12

select businessdata,DATEDIFF(day,BusinessData,getdate())from dbo.THQ801MemberCardConsume 
where 
DATEDIFF(day,BusinessData,getdate())=0 -- 当天
or DATEDIFF(day,BusinessData,getdate())=1 -- 前一天