I am not sure if this will work with Oracle. I would like to know, so if
you could try out this test :
http://www.foxforum.com/showfullmessage.cfm?messageID=12382
If it does work, then you should be able to do this:
ldDby = date()-2
lnRet = sqlexec( h, "select * from Table where InputDate>=?ldDby" )
Carl Karsten
"Jason" <[EMAIL PROTECTED]> wrote in message
9l19vh$9ku$[EMAIL PROTECTED]">news:9l19vh$9ku$[EMAIL PROTECTED]...
> I am trying to retrieve records generated in the passed two days and
> encountered difficulties in dealing with the date in Oracle.
> Here is the query I try to form:
>
> select * from Table where InputDate>=[the day before yesterday]
>
> I tried "sysdate-2", didn't work.
> Any suggestions?
> Thanks!
>
> Jason
>
>
>
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
