How to calculate the time variation between two different time sessions?

Sudhir Sorout

 Profile Answers by Sudhir Sorout Questions by Sudhir Sorout

• Feb 4th, 2008

Select t1- t2 from dualwhere t1 and t2 are dates then this query will return no of day not hrs.Sudhir Sorout

gbansal4

 Profile Answers by gbansal4 Questions by gbansal4

• Dec 15th, 2007

Select t1 - t2 from dualwhere t1 & t2 are dates.  It will give output in hours.

Answer Question  Select Best Answer

How to know the days or months or years between two employees in emp table.

jbabu

 Profile Answers by jbabu Questions by jbabu

• Dec 10th, 2007

Select hiredate,lead(hiredate,1) over(order by hiredate) next_months, round(months_between(lead(hiredate,1) over(order by hiredate),hiredate),3) months from emp;

Answer Question  Select Best Answer