How to check if a customer’s birthday has passed for the ongoing year?

I have a table storing information about customers which includes a column “dateofbirth”. I need to fetch those customers whose birthday has passed for the ongoing year (2015). How can I extract both date and month and compare it with system date and month?


Source: oracle

Leave a Reply