两日期相减与日期减掉天数(sqlServer)
两日期相减与日期减去天数(sqlServer)
select datediff(d,'2012-05-10',getdate()) as day from table --两日期相减
dateadd(d,-"+waringDay+",stopdate) as day --日期减去一天数