Question:

Hello Everyone
I am currently trying to write a query that I am having a hard time
with maybe you can help. I am trying to write a query that shows
everyone's birthday for the current month. I am having a hard time
specifying the month. This query should run on any month without
modification. I believe that I will have to use the sysdate function
and the last_day function but I am not sure how to put it together!

Thanks for the help
Liam

Answer:

select *
  from T
 where to_char( birth_date, 'MM' ) = to_char(sysdate,'MM')
/