oracle TIMESTAMP日期相减
时间：2021-07-01 10:21:17
帮助过：28人阅读
* 60 * 60 + extract(minute from inter) * 60 +
extract(second from inter) "seconds"
from (select to_timestamp(‘20100115112233‘, ‘yyyymmddhh24miss‘) -
to_timestamp(‘20100101123456‘, ‘yyyymmddhh24miss‘
) inter
from dual);
oracle TIMESTAMP日期相减
标签：
