select to_char(sysdate, 'Month') from dual
in your example will be:
select to_char(to_date('15-11-2010', 'DD-MM-YYYY'), 'Month') from dual
to_char(mydate, 'MONTH') will do the job.
to_char(mydate, 'MONTH')
Try this,
select to_char(sysdate,'dd') from dual; -> 08 (date)select to_char(sysdate,'mm') from dual; -> 02 (month in number)select to_char(sysdate,'yyyy') from dual; -> 2013 (Full year)