Between two dates

[jestin]

hi friends

i am trying to upgrade one sql query to oracle 8i,and i am facing one problem can any one help in this situation.in that query we need a some data in between two times

ASP code is as follows
set rscheck = Server.CreateObject("ADODB.Recordset")
sqlcheck = "SELECT Tbl_RequestInfo.ReqServicetypeid, Tbl_RequestInfo.ReqArea, Tbl_RequestInfo.ReqRschedDate, Tbl_RequestSched.RschedTime, " &_
"FROM Tbl_RequestInfo INNER JOIN Tbl_RequestSched ON Tbl_RequestInfo.ReqID = Tbl_RequestSched.RschedReqid " &_
"WHERE (((Tbl_RequestInfo.ReqServicetypeid)=" & ReplaceQuote(textservicetype) & ") AND ((Tbl_RequestInfo.ReqArea)=" & STR_Quote2(ReplaceQuote(textservicearea)) & ") " &_
"AND ((Tbl_RequestInfo.ReqRschedDate)='"& FormatDateTime(textsched,2) & "') " &_
"AND ((Tbl_RequestSched.RschedTime) Between " & DateDelimiter(FormatDateTime(("schedSTime"),4)) & " And " & DateDelimiter(FormatDateTime(("schedETime"),4)) & ") " &_
"ORDER BY Tbl_RequestSched.RschedTime"


i need a data in between schedSTime & schedETime. can any one rectify my between operation is correct or not

thx

[DrBunchman]

Hi Jestin,

I think Oracle needs to have apostrophe's around any date variables so putting those in might fix your problem.

If not, are you receiving an error when you run the above?

Dr B