Re: Help with date query

hmm if you want to ensure it only returns the previous day i would write it like this:

select * from mytable where entry_date between trunc(sysdate-1) and trunc(sysdate) Received on Tue May 08 2007 - 10:24:59 CDT