We help IT Professionals succeed at work.

Oracle 11g - Query To get the time between to date/time

Hi all

In my query, i'm pulling 2 dates from 2 columns like bellow:
TO_CHAR(LS.EARLY_ARRV, 'YYYY-MM-DD HH24:MI') AS ARRIVAL_PLANNED, 
TO_CHAR(LS.DEPART, 'YYYY-MM-DD HH24:MI') AS DEPARTURE_PLANNED,

Open in new window


What i would like to do is to count the elapse time between them. how can i include this in the query?
Something like:
(TO_CHAR(LS.DEPART, 'YYYY-MM-DD HH24:MI') - TO_CHAR(LS.EARLY_ARRV, 'YYYY-MM-DD HH24:MI')) 

Open in new window


I would need to get the result in 0.00 format.

Thanks for your help.
Comment
Watch Question

Most Valuable Expert 2011
Top Expert 2012

Commented:
what does 0.00  represent?  days? hours? minutes?
Most Valuable Expert 2011
Top Expert 2012
Commented:
round(ls.depart - ls.early_arrv,2)    - this will return result in days

round((ls.depart - ls.early_arrv) * 24,2)    - this will return result in hours

round((ls.depart - ls.early_arrv) * 1440,2)    - this will return result in minutes

round((ls.depart - ls.early_arrv) * 86400,2)    - this will return result in seconds
Thank you so much, just what i needed.

round((ls.depart - ls.early_arrv) * 24,2)    - this will return result in hours