select datename(mm,getdate())

in ms-access we can use
select format(date(),'mmmm')

In Oracle,

SELECT to_char(sysdate,'month') from dual

select datename(month,parametername or columnname) from 
tablename

FOR POSTGRES DATABASE
SELECT to_char(NOW(),'month')

In Oracle make the first letter capital if you wish the 
output names also capitalised. "Month" instead of "month"

SELECT CONVERT(varchar,GETDATE(),0)
Return Value = Jun 6 2007

select month(getdate()) 
select month(dateparametername) from tablename
---here u will get number of month
or 

select datename(month,getdate())
select datename(month,dateparametername) from tablename
to get name of month

In Oracle 

select to_char(sysdate, 'dd/mm/yyy')as year from dual


EG:-

select ed.emp_date_of_birth,ed.first_name,ed.last_name 
from emp_details ed where
to_char(ed.emp_date_of_birth,'mm')=to_char(sysdate,'mm')