select * from table_name where date_col between
to_date('01/01/00','MM/DD/RR') and to_date('02/01/00','MM/DD/RR');
--
Robert Fazio, Oracle DBA
rfazio_at_home.com
remove nospam from reply address
http://24.8.218.197/
"Margaret Burwell" <aj739_at_FreeNet.Carleton.CA> wrote in message
news:8f6mmt$6j2$1_at_freenet9.carleton.ca...
>
> I know this is a simple problem, but for some reason it is giving me all
> kinds of headaches. I want to query a table for all rows in which the
> reference_date falls between two specific dates. The reference_date
> column is defined as date.
>
> Marg
Received on Mon May 08 2000 - 00:00:00 CDT
