语法:DATEDIFF(datepart,startdate,enddate)
startdate 和 enddate 参数是合法的日期表达式.格式需一样
datepart的参数值
天数差:SELECT DATEDIFF(day,startdate,enddate) as diffdate
语法:DATEDIFF(datepart,startdate,enddate)
startdate 和 enddate 参数是合法的日期表达式.格式需一样
datepart的参数值
天数差:SELECT DATEDIFF(day,startdate,enddate) as diffdate
转载于:https://my.oschina.net/u/3899374/blog/3092843