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.

Other related posts: