两日期相减与日期减掉天数(sqlServer)

两日期相减与日期减去天数(sqlServer)

select datediff(d,'2012-05-10',getdate()) as day from table??--两日期相减

dateadd(d,-"+waringDay+",stopdate) as day?????? ?--日期减去一天数

?