RE: SQL help

omg .. please tune this... select * from dual;  

I feed baaad today... must be fryday

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of ora_forum
Sent: Friday, October 21, 2005 1:58 PM
To: oracle-l_at_freelists.org
Subject: SQL help

Hi All,

I need find data, which are meet criteria 10 minutes before and 10 minutes after specific time. This is what I have and it's not working properly with between function:  

select id_number from test where status = 'X' and id_number in

(select id_number from test where to_date(to_char (changed_on,'MM/DD/YYYY HH24:MI'),'MM/DD/YYYY HH24:MI') in

select to_char (audit_timestamp,'MM/DD/YYYY HH24:MI') from result_table

        where to_date(to_char (audit_timestamp,'MM/DD/YYYY HH24:MI'),'MM/DD/YYYY HH24:MI')         between

        to_date(to_char (audit_timestamp - 1/288,'MM/DD/YYYY HH24:MI'),'MM/DD/YYYY HH24:MI')         and

        to_date(to_char (audit_timestamp + 1/288,'MM/DD/YYYY HH24:MI'),'MM/DD/YYYY HH24:MI');   Thanks.

Yahoo! FareChase - Search multiple travel sites in one click. <http://us.lrd.yahoo.com/_ylc=X3oDMTFqODRtdXQ4BF9TAzMyOTc1MDIEX3MDOTY2ODgxNj kEcG9zAzEEc2VjA21haWwtZm9vdGVyBHNsawNmYw--/SIG=110oav78o/**http%3a//farechas e.yahoo.com/>

--
http://www.freelists.org/webpage/oracle-l