Oracle SQL: Fetch Monday to Friday dates based on current date or inputted date
10 months ago 23
Requirement:
Fetch Monday to Friday dates based on current date or inputted date.
Solution
select to_char(dow,'DAY')||' '||to_char(dow,'DD-MON-YYYY') display_date,dow date_returnedfrom (select next_day(to_char(sysdate,'DD-MON-YYYY'),'MONDAY')+ (rownum-1) - 7 DOWfrom dualconnect by level <= 5);
Replace "sysdate" with any date paremeter.
Acknowledgement
Displaying week days for current week - Ask TOM (oracle.com)
