oracle TIMESTAMP日期相减
标签：
oracle TIMESTAMP日期相减
* 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);