? ? ? ? ? ? ? ? ? ? ? ? ? ?計算兩個時間列的差值

需求描述

需求：對EMP表里員工KING和SMITH的hiredate入職時間差，這里單位是分鐘、小時、天、周、月、年.

解決方法:通過DATEDIFF函數來完成.

注: 數據庫數據集SQL腳本詳見如下鏈接地址

員工表結構和數據初始化SQL腳本

SQL代碼

-- Mysql： SELECT B.ename b_Ename,B.HIREDATE b_hiredate,A.ename a_Ename, A.HIREDATE a_hiredate, TIMESTAMPDIFF(MINUTE,A.HIREDATE,B.HIREDATE) minute_diff, TIMESTAMPDIFF(HOUR,A.HIREDATE,B.HIREDATE) hour_diff, DATEDIFF(B.HIREDATE,A.HIREDATE) day_diff, TIMESTAMPDIFF(WEEK,A.HIREDATE,B.HIREDATE) week_diff,TIMESTAMPDIFF(MONTH,A.HIREDATE,B.HIREDATE) month_diff, TIMESTAMPDIFF(YEAR,A.HIREDATE,B.HIREDATE) year_diff FROM emp A,emp B WHERE A.ename = 'SMITH' AND B.ename = 'KING'

執行結果

-- SQL Server： SELECT B.ename b_Ename,B.HIREDATE b_hiredate,A.ename a_Ename, A.HIREDATE a_hiredate ,DATEDIFF(MINUTE,A.HIREDATE,B.HIREDATE) minute_Diff ,DATEDIFF(HOUR,A.HIREDATE,B.HIREDATE) hour_Diff ,DATEDIFF(DAY,A.HIREDATE,B.HIREDATE) day_Diff ,DATEDIFF(WEEK,A.HIREDATE,B.HIREDATE) week_Diff ,DATEDIFF(MONTH,A.HIREDATE,B.HIREDATE) month_Diff ,DATEDIFF(YEAR,A.HIREDATE,B.HIREDATE) year_Diff FROM emp A,emp B WHERE A.ename = 'SMITH' AND B.ename = 'KING'

總結

以上是生活随笔為你收集整理的处理时间_2_计算两个时间列的差值的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。