Oracle与Mysql的日期相减

一、Oracle日期相减

1、两个Date类型数据相差的小时数

SELECT t.end_time,t.begin_time,ROUND((t.end_time-t.begin_time)*24,2)
FROM FBS_ZXSJ t;

2、两个Timestamp类型数据相差的小时数

SELECT  t.end_time_,t.start_time_,ROUND((CAST(t.end_time_ AS DATE)-cast(t.start_time_ AS DATE))*24, 2)
FROM ACT_HI_TASKINST t;

3、一个Date类型数据和一个Timestamp类型数据相差的小时数

SELECT t2.end_time_,t1.begin_time,ROUND((CAST(t2.end_time_ AS DATE)-t1.begin_time)*24,2)
FROM FBS_ZXSJ t1, ACT_HI_TASKINST t2;

二、Mysql日期相减

-- 两个Date类型数据的相差的小时数
SELECT t.end_time,t.begin_time,round((time_to_sec(end_time)-time_to_sec(t.begin_time))/3600, 2)
FROM FBS_ZXSJ t;

-- 两个Timestamp类型数据的相差的小时数
SELECT  t.end_time_,t.start_time_,round((time_to_sec(end_time_)-time_to_sec(t.start_time_))/3600, 2)
FROM ACT_HI_TASKINST t;

-- 一个Date类型数据和一个Timestamp类型数据相差的小时数
SELECT t2.end_time_,t1.begin_time,round((time_to_sec(t2.end_time_)-time_to_sec(t1.begin_time))/3600, 2)
FROM FBS_ZXSJ t1, ACT_HI_TASKINST t2;