Niraj Choubey Niraj Choubey - 8 months ago 70
SQL Question

get month name from date in oracle

How to fetch month name from a given date in oracle?
if the given date is '15-11-2010' then i want November from this date.
please help.

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