title: Convert Date into simple DD-MM-YYYY HH24:MI:SS format in SQL
body: <p>I have a date passed as a string with this format:</p>
  
  <pre><code>Fri Dec 04 01:00:00 CST 2015
  </code></pre>
  
  <p>Anyone know how to convert it into <code>DD-MM-YYYY HH24:MI:SS</code> format in Oracle? I'm trying to look for samples but can't seem to find any.</p>
  
  <p>Result should be:</p>
  
  <pre><code>04-12-2015 01:00:00
  </code></pre>
  
  <p>(not sure if the time is right since it has CST)</p>
  
  <p>I can have the string passed into Java, so if there are easier ways to transform it in Java it's fine with me.</p>