oracle convert DD-MON-YY to DD/MM/YYYY
<p>I am trying to convert the format of a varchar2 column from '<strong>DD-MON-YY</strong>' to '<strong>DD/MM/YYYY</strong>'.</p>

<p>In example: from '<strong>01-JAN-16</strong>' to '<strong>01/01/2016</strong>'</p>

<p>In case you can ask or it may help:</p>

<ul>
<li>'MON' part is in English however my current NLS settings are in Turkish.</li>
<li>All the years are after 2000.</li>
</ul>

<p>How can I do this?
Thanks in advance..</p>