![Business Days In Current Month [Excluding Sat Sun]](https://cdn.blogarama.com/images/posts_thumbs_site_id/2509/250903-854818480.jpg "Business Days In Current Month [Excluding Sat Sun]")
You can use the following SQL to get the number of working days (not including sat and sun) of the Current month
SELECT COUNT(TRUNC(SYSDATE,'MM') +(LEVEL-1)) AS BUSINESS_DAYS_IN_MT FROM DUAL WHERE TO_CHAR(TRUNC(SYSDATE,'MM') +(LEVEL-1),'D') NOT IN (1,7) CONNECT BY LEVEL Add this as a REPOSITORY VARIABLE and can be use in the reports for calculations |
This post first appeared on The Big Data - Business Intelligence By Sandeep Venu, please read the originial post: here
