SQL help

From: ora_forum <ora_forum_at_yahoo.com>
Date: Fri, 21 Oct 2005 10:58:16 -0700 (PDT)
Message-ID: <20051021175816.81275.qmail@web36709.mail.mud.yahoo.com>

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://www.freelists.org/webpage/oracle-l

Received on Fri Oct 21 2005 - 14:06:10 CDT