Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Help with date query

Re: Help with date query

From: Problematic coder <gnewsham_at_gmail.com>
Date: 8 May 2007 12:28:58 -0700
Message-ID: <1178652538.699004.325750@p77g2000hsh.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US