try it. One word of advice don't do it that way. You are counting on a
particular nls date format. Instead wrap the strings in to_date eg
to_date('01-JAN-2003','dd-mmm-yyyy')
Jim
--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family. Remove the negative part, keep the minus sign. You can figure
it out.
"Just_Buy" <ohbej_at_hotmail.com> wrote in message
news:65275ae5.0306250757.b859f09_at_posting.google.com...
> Which of the following methods is faster for retrieving records within a
date range?
>
> Option A:
> Paid_Date >= '01-JAN-2003' AND Paid_Date <= '01-MAR-2003'
>
> Option B:
> Paid_Date BETWEEN '01-JAN-2003' AND '01-MAR-2003'
>
> Thanks!
Received on Wed Jun 25 2003 - 21:51:00 CDT
