1 Reply Latest reply: Sep 26, 2011 3:02 PM by tychos RSS

    how to do find the difference between two time stamps

    877826
      Hi all,

      i have a table with 2 columns called GMT time and Local time . so i need to find difference between these two time stamps.

      i tried like this

      select to_date(GMT_TIME,'yyyy-mm-dd hh24:hi:ss')-to_date(LOCAL_TIME,'yyyy-mm-dd hh24:hi:ss') from date_table

      the result is coming as follows ..
      0.291666666667

      i did not under stand the out put.

      In my table GMT_TIME= 2011-06-26 00:00:00 and LOCAL_TIME=2011-06-25 17:00:00 ..

      please help me how to get exact hours between two dates ..


      Thanks
      Sreedhar