1、日期减去8小时
SELECT ADD_SECONDS(TO_SECONDDATE('2024-04-09 10:23:50', 'yyyy-MM-dd hh24:mi:ss'),-28800) FROM dummy;
2、日期加8小时
SELECT ADD_SECONDS(TO_TIMESTAMP('2024-04-09 10:23:50', 'yyyy-MM-dd hh24:mi:ss'),8*60*60) FROM dummy;
3、日期差函数
--时间差换算 计算日期参数 d1 和 d2 之间的秒数,语义上等同于 d2-d1。
--语法:SECONDS_BETWEEN (d1, d2)
SELECT SECONDS_BETWEEN ('2015-01-01 01:01:01', '2015-01-01 02:01:01') seconds_between FROM DUMMY;--3600
SELECT SECONDS_BETWEEN ('2015-01-01 01:01:01', '2015-01-01 01:02:02') seconds_between FROM DUMMY;--61
SELECT SECONDS_BETWEEN ('2015-01-01 01:01:01', '2015-01-01 01:01:02') seconds_between FROM DUMMY;--1