<div>
<div class="content wysiwyg-content">
select to_char(to_date('03/2008',<wbr />'mm/yyyy')<wbr />) from dual<br />
<br />
here the output is 1st march 2008<br />
<br />
I just want march 2008<br />

</div>
</div>


select to_char(to_date('03/2008','mm/yyyy')) from dual

here the output is 1st march 2008

I just want march 2008


Return month and Year

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.