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 ..
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 ..