Re: SQL help

select *
from my_table
where audit_timestamp between (specified_time-(1/144)) and (specified_time-+1/144))
/

On 10/21/05, ora_forum <ora_forum_at_yahoo.com> wrote:
>
> 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=X3oDMTFqODRtdXQ4BF9TAzMyOTc1MDIEX3MDOTY2ODgxNjkEcG9zAzEEc2VjA21haWwtZm9vdGVyBHNsawNmYw--/SIG=110oav78o/**http%3a//farechase.yahoo.com/>
>
>

--
------------------------------
select standard_disclaimer from company_requirements where category =
'MANDATORY';
--
http://www.freelists.org/webpage/oracle-l