Access backend vs mysql backend

I just started to use mysql as the back end and I was just wondering how it
is different from using access as a backend. Some of the querys that I wrote
in access won't work with mysql as the back end. Specifically I was wondering
how the date and month function differs. In Access I had a query with the
WHERE condition as:

Month(date()) = (Month([Date Of Birth])

but this wont work with the mysql backend. THe query just returns no records
and it will not let me sort them by the month in the Month([Date Of Birth])