select datediff(DAY,'2012/8/1','2012/8/20') as daysum
//注解:MONTH为月、DAY为查询天、HOUR为小时、MINUTE为分钟、SECOND为秒
select datediff(DAY,'2012/8/1','2012/8/20') as daysum
//注解:MONTH为月、DAY为查询天、HOUR为小时、MINUTE为分钟、SECOND为秒
转载于:https://www.cnblogs.com/lydg/p/11362290.html