读书人

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

发布时间: 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?????? ?--日期减去一天数

?

读书人网 >SQL Server

热点推荐