Calculate difference in hours between 2 timestamp fields

select time1

  2         , time2

  3         , extract(day from time1-time2) days

  4         ,  extract(hour from time1-time2) hh

  5         , extract(minute from time1-time2) mi

  6         , extract(second from time1-time2) ss

  7  from example;