title: how to get the date format in 'DD-MM-YY' format in ORACLE without using TO_CHAR?
body: <p>How do we convert a date in the 'DD-MM-YY' format <strong>WITHOUT</strong> using to_char ?
  If I use the following query i get it in DD-Mon-YY format ?</p>
  
  <pre><code>select TO_DATE(SYSDATE,'DD-MM-YY') from dual ;
  </code></pre>
  
  <p>Output : 29-Mar-18</p>
  
  <p>I want it in 29-03-18 format , <strong>without using to_char</strong>.
  Is it possible ?</p>