Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Help with date query
On May 8, 8:24 am, "knightconsult..._at_gmail.com"
<knightconsult..._at_gmail.com> wrote:
> 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)
You are correct sir, however I was looking for the last business day
which if the query is run on a Monday would be Friday, holidays also
to be taken into account.
Geoff gave me just what I was looking for but I do appreciate your
feedback and time - thank you
Received on Tue May 08 2007 - 14:28:58 CDT
![]() |
![]() |