例如,我需要
的日期差异1.declare @ldfrom date ='2016-12-01', @ldto date ='2018-05-31'
结果:
18 noofmnth,
0 nofweek,
0 noofdays
2.declare @ldfrom date ='2016-12-31', @ldto date ='2018-05-25'
结果:
17 noofmnth,
3 nofweek,
4 noofdays
使用netatediff
select DATEDIFF(wk,'2016-12-01','2018-05-31')+1