select ... from mytable where to_date('01/15/2001','mm/dd/yyyy')
<=theDateColumn and to_date('01/20/2001','mm/dd/yyyy') >=theDateColumn
Jim
"Neil Ray" <urneil_at_rediffmail.com> wrote in message
news:b44e67ab.0110060641.2e20b72c_at_posting.google.com...
> Hello,
> Can U pls help me with the syntax for searching a list of records from
> a particular day to a particular day ie.(all records between 15 jan
> 2001 TO 20 jan 2001).
> PS: How can I use it in VB6
> Thanks
> Neil Ray
Received on Sat Oct 06 2001 - 11:24:37 CDT
