SQL server的时间差代码

SQL server的时间差代码

1.以下是各类时间差的方式

/*
时间差
*/
/*年*/
SELECT DATEDIFF(YEAR,'2008-12-30 13:00','2010-12-30 13:00:30') AS 年
/*月*/
SELECT DATEDIFF(MONTH,'2008-11-30 13:00','2008-12-30 13:00:30') AS 月
/*日*/
SELECT DATEDIFF(DAY,'2008-12-30 13:00','2008-12-31 13:00:30') AS 日
/*时*/
SELECT DATEDIFF(HOUR,'2008-12-30 13:00','2008-12-30 18:00:30') AS 时
/*分*/
SELECT DATEDIFF(MINUTE,'2008-12-30 13:00','2008-12-30 13:10:30') AS 分
/*秒*/
SELECT DATEDIFF(SECOND,'2008-12-30 13:00','2008-12-30 13:00:30') AS 秒
/*毫秒*/
SELECT DATEDIFF(MICROSECOND,'2008-12-30 13:00','2008-12-30 13:00:50') AS 毫秒

2.相关运行效果如下：