----计算时间差
相差年数:SELECT DATEDIFF(YEAR,'2017-07-01 11:25:52','2018-07-02 12:25:52'); 结果:1
相差天数:SELECT DATEDIFF(DAY,'2018-07-01 11:25:52','2018-07-02 12:25:52'); 结果:1
相差小时:SELECT DATEDIFF(HOUR,'2018-07-01 11:00:00','2018-07-01 16:00:00'); 结果:5
相差分数:MINUTE,相差秒数:SECOND,相差月数:MONTH