Re: the day before yesterday.

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" <jzhu(at)dental(dot)temple(dot)edu> wrote in message
news:9l19vh$9ku$1(at)cronkite(dot)temple(dot)edu(dot)(dot)(dot)
> 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
>
>
>