两日期相减与日期减去天数(sqlServer)
select datediff(d,'2012-05-10',getdate()) as day from table??--两日期相减
dateadd(d,-"+waringDay+",stopdate) as day?????? ?--日期减去一天数
?
发布时间: 2012-08-13 13:21:53 作者: rapoo
两日期相减与日期减去天数(sqlServer)
select datediff(d,'2012-05-10',getdate()) as day from table??--两日期相减
dateadd(d,-"+waringDay+",stopdate) as day?????? ?--日期减去一天数
?