Re: Need Urgent Help with SQL Syntax & Oracle

Take a look at the 'between' operator.

You could do something like

SELECT *
FROM table1, table2
WHERE table1.date between ( table2.date - (60 * 60 * .1) ) and ( table2.date + (60 * 60 * .1) );

I hope I got the calculation right for specifying the time.

tjaenichen_at_hotmail.com (Thorsten) wrote in message news:<79ab94fa.0109040243.5a681b81_at_posting.google.com>...
> Hi,
>
> *******LONG EXPLANATION, SKIP IT IF U LIKE AND JUMP RIGHT INTO THE
> QUESTION AT THE BOTTOM
>
> QUESTION:
> Now my Question is, is there a way to do something like:
>
> SELECT * FROM table1, table2 WHERE
> table1.date isPlusMinusOneHourOf table2.date
Received on Tue Sep 04 2001 - 17:52:05 CEST