Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Oracle (http://www.go4expert.com/forums/oracle-forum/)
-   -   How can i calculate calendar 's weekly off days in Oracle (http://www.go4expert.com/forums/i-calculate-calendar-s-weekly-days-t15143/)

Teji 15Nov2008 17:39

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

xpi0t0s 16Nov2008 15:22

Re: How can i calculate calendar 's weekly off days in Oracle
 
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).


All times are GMT +5.5. The time now is 00:46.