RE: SQL help
- From: "Spears, Brian" <BSpears@xxxxxxxxxxxxxxxxx>
- To: <ora_forum@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 21 Oct 2005 15:39:37 -0400
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:
