CODE EXAMPLE FOR SQL

sql date get month

-- Will return 'November'
select to_char(to_date('15-11-2010', 'DD-MM-YYYY'), 'Month') from dual