Re: Help - "Business Day" Problem
- From: sybrandb <sybrandb@xxxxxxxxx>
- Date: 27 Apr 2007 06:04:42 -0700
On Apr 27, 2:58 pm, "pankaj_wolfhun...@xxxxxxxxxxx"
<pankaj_wolfhun...@xxxxxxxxxxx> wrote:
Greetings,
I have a requirement where an input date will be provided and I
have to
update a table with the date previous to input_date (input_date - 1)
All I have to make sure is input_date - 1 should not be 'SAT' or 'SUN'
and should not be
in our holiday table.
Something like
UPDATE TABLE1
SET final_date =(SELECT input_date - 1
FROM ...
WHERE TO_CHAR(TO_DATE ('input_date') - 1,'DY') NOT IN
('SAT','SUN')
AND NOT EXISTS (SELECT h_holiday from holiday where h_holiday =
input_date)
My question do we need the FROM clause in the subquery? If yes, what
to specify as this is just an
input date and not from any table.
Any help would be appreciated.
TIA
a) Yes
b) this is what DUAL was invented for (OK: Originally it was used to
send printer specific codes to output as the PROMPT command in
sql*plus didn't yet exist)
--
Sybrand Bakker
Senior Oracle DBA
.
- Follow-Ups:
- Re: Help - "Business Day" Problem
- From: pankaj_wolfhunter@xxxxxxxxxxx
- Re: Help - "Business Day" Problem
- References:
- Help - "Business Day" Problem
- From: pankaj_wolfhunter@xxxxxxxxxxx
- Help - "Business Day" Problem
- Prev by Date: Help - "Business Day" Problem
- Next by Date: Re: apache, tomcat, oracle, hibernate
- Previous by thread: Help - "Business Day" Problem
- Next by thread: Re: Help - "Business Day" Problem
- Index(es):
Relevant Pages
|
