How can i calculate calendar 's weekly off days in Oracle

Teji's Avatar, Join Date: Sep 2008
Light Poster
How can i calculate calendar 's weekly off days in Oracle
xpi0t0s's Avatar, Join Date: Aug 2004
Mentor
You need a day of week function (RTFM for TO_CHAR), then if this represents Sunday as 0, Monday as 1 etc and if your offdays are Tuesday and Thursday then it's just if (day==2 || day==4) (using C syntax, but you can translate that into PL/SQL easily enough).