Exclude weekends from query
714604Feb 16 2012 — edited Mar 4 2012Hi All,
From Oracle apps I want to find out the value of
variable = request_date - sysdate
if request_date is tomorrow then I will get the value as 1 (sysdate+1 - sysdate).
if request_date is 20-Feb-12 which is monday, by excluding the weekend daya I should get the value as 2 (because
20-Feb-2012 - sysdate which is 4, it should exclude weekendays and should show the value as 2)
Can any one please give me a query or logic to get the correct result,
Thanks in advance.
Satya Koppula