Datediff in Oracle SQL?

[kunzi]

Suppose I have two SQL expressions now:

1. exp1

select date_1
from table_1
where blah blah

2. exp2

Select date_2
from table_2
where blah blah

How can I get the date difference in hours between the two dates returned above? I guess simply exp1-exp2 won't work...

Thanks!

 

[SkipVought]

hi,

how are the two tables logically related?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[kunzi]

Table_1 left outer joins Table_2.

 

[SkipVought]

post your outer join sql please, with the two dates.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[lbass]

You should be able to just use a formula:

datediff("n",{%exp1},{%exp2})

...where {%exp2} is the more recent date.

-LB

 

[lbass]

For hours, that should have been:

datediff("h",{%exp1},{%exp2})

"n" is for minutes (to distinguish it from "m" for months.

-LB