Convert Date into simple DD-MM-YYYY HH24:MI:SS format in SQL
<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>