I need to create a query which will select a request_no between Data1 and
Date2 so...
SELECT request_no FROM request where status_code ='C' and (completed_date
between 01/01/2000 and 01/01/2001);
The problem I have run into is that the completed_date field is a datetime
format (not by my own design) and I am having some problems extracting just
the request_no's between those dates.
I have tried a few extract month,day,year clauses with no success. If
anyone has an idea I would appreciate it!
Thanks in advance.
Mark
