gbansal4

 Profile Answers by gbansal4 Questions by gbansal4

• Dec 15th, 2007

 

select t1 - t2 from dual

where t1 & t2 are dates.  It will give output in hours.

Sudhir Sorout

 Profile Answers by Sudhir Sorout 

• Feb 4th, 2008

 

select t1- t2 from dual
where t1 and t2 are dates then this query will return no of day not hrs.

Sudhir Sorout