Niraj Choubey Niraj Choubey - 2 years ago 243
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.

Answer Source
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
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download