I've a table with employees and their birth date, in a column in a format string. I cannot modify the table, so I created a view to get their birth date in a real date format (TO_DATE).

Now, I would like to get the list of the employees having theirs birthday in the last 15 days and the employees who'll have theirs birthday in the next 15 days. So, just based with the Day and the month.

I successfully get for exemple all employees bornt in April with "Extract", but, I'm sure you've already understand, when I'll run the query the 25 April, I'd like the futures birthday in May.

How could I get that (oracle 12c)

Thank you