Could anyone tell me how can I write the following SQL:

select * from employer
where month(emp_date) = 'Mar'


emp_date in format dd/mm/yyyy

Thank you very much.