[VB_Oracle]

Hi,

I'm trying to find the difference between two dates (w/times) in terms of hours...can someone please modify the below pseudo-query so it does that, thanks.

select (date1 - date2)
from table1;

[satish_ct]

Hi,

Already you have posted this query in the ORACLE Forum.

[shelva]

u have to use it like this

select (date2-date1) * 24 * 60 from !!!! to get in minutes

because date2-date1 gives u a value in number of days..
multiply it by 24 gives you number of hours
multiply it by 24 * 60 gives you number of minutes
multiply it by 24 * 60 *60 gives you number of seconds

regards