SQL> ED
Wrote file afiedt.buf
1 SELECT ((NEXT_DAY(LAST_DAY(TRUNC(SYSDATE))-7,'THURSDAY') -NEXT_DAY(TRUNC(SYSDATE,'MONTH')-1,'T
2* FROM DUAL
SQL> /
THURSDAYS
----------
4
[b]
And here is a more generic function..to find count of all the days. Input is start date of the month [/b]
SELECT DECODE(TO_CHAR(TO_DATE('01-JUNE-02') + ROWNUM - 1,'D'),
1, 'SUNDAY',
2,'MONDAY',
3,'TUESDAY',
4,'WEDNESADY',
5,'THURSDAY',
6,'FRIDAY',
7,'SATURDAY') DAY, COUNT(1)
FROM DBA_OBJECTS
WHERE ROWNUM <= TO_CHAR(LAST_DAY('01-JUNE-02'),'DD')
GROUP BY TO_CHAR(TO_DATE('01-JUNE-02') + ROWNUM - 1,'D')
ORDER BY TO_CHAR(TO_DATE('01-JUNE-02') + ROWNUM - 1,'D')
SQL> /
DAY COUNT(1)
--------- ----------
SUNDAY 5
MONDAY 4
TUESDAY 4
WEDNESADY 4
THURSDAY 4
FRIDAY 4
SATURDAY 5
7 rows selected.