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