SQL help
- From: ora_forum <ora_forum@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 21 Oct 2005 10:58:16 -0700 (PDT)
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:
