RE: SQL help

omg .. please tune this... select * from dual;
 
I feed baaad today... must be fryday

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of ora_forum
Sent: Friday, October 21, 2005 1:58 PM
To: oracle-l@xxxxxxxxxxxxx
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/>

Other related posts: