You say “SELECT” and so I assume you are using SQL.
Most flavors of SQL have a function to extract the month from a date. And also a special register for CURRENT DATE. Using this MONTH function makes your query very easy… something like this …
SELECT column1, column2, …, birthdate
WHERE MONTH(birthdate) = MONTH(CURRENT DATE)
ORDER BY …
I hope this helps.