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 -> this cannot be then best way

this cannot be then best way

From: <g>
Date: Fri, 14 Jul 2006 17:38:32 +0100
Message-ID: <MNWdnYMyuLlrVSrZRVnyrQ@bt.com>


I have a date mydate and i want to subtract X working days off

i was thinking of something like

loop while x > 0
if to_char(mydate,'d') < 6 then
x = x -1
endif
 mydate :mydate - 1
endloop

any ideas Received on Fri Jul 14 2006 - 11:38:32 CDT

Original text of this message

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