SQL genius help for custom query

I know there are some legends with SQL out there.
What I need to do is create a custom query using the following path

Select from m_info
table m_dob

I then need to split the m_dob to day, month and compare it to the current day, month of the server.

Does anyone have any ideas??