title: to display date in the format of ‘YYYY-MM-DD’ when the date is given in the form 1-JAN-2011?
body: <p>I have to write a query to display schedule id and date in the format of ‘YYYY-MM-DD’.
  can anyone help me with it</p>
  
  <p>travel date is this</p>
  
  <pre><code>TRAVEL_DA
  ---------
  - 09-MAY-16
  - 17-MAR-16
  - 26-AUG-16
  - 30-APR-16
  - 17-AUG-16
  </code></pre>
  
  <p>and I want to get this output</p>
  
  <pre><code>FORMATTEDD
  --- ----------
   - 2016-05-09
   - 2016-03-17
   - 2016-08-26
   - 2016-04-30
   - 2016-08-17
  </code></pre>