Software Applications Programming Errors and solutions.

How to select particular day date from given month in SQL. You can see below example to get some ideas. select dates,to(char(dates,'day-mon-yyyy') from (select to_date(:start_date,'dd-mon-yyyy')+rownum -1 as dates from all_objects where rownum<=to_date(:end_date,'dd-mon-yyyy')- to_date(:start_date,'dd-mon-yyyy')+1) where upper(regexp_substr(to_char(dates,'day-mon-yyyy'),'([[:alpha:]])+'))=upper(:day_name); 02-JUN-17 FRIDAY 09-JUN-17 FRIDAY 16-JUN-17 FRIDAY 23-JUN-17 FRIDAY 30-JUN-17 FRIDAY 07-JUL-17 FRIDAY 14-JUL-17 FRIDAY 21-JUL-17 FRIDAY 28-JUL-17 FRIDAY 04-AUG-17 FRIDAY 11-AUG-17 FRIDAY 18-AUG-17 FRIDAY 25-AUG-17 FRIDAY 01-SEP-17 FRIDAY