title: TO_CHAR and TO_DATE giving different results.How to achieve the TO_CHAR functionality using TO_DATE?
body: <pre><code>SELECT TO_CHAR((select logical_date -1 from logical_date 
  where logical_date_type='B'),'DD/MM/YYYY HH24:MI:SS') FROM DUAL;
  </code></pre>
  
  <p>This Query returns <code>23/04/2016 00:00:00</code></p>
  
  <pre><code>o/p of select logical_date -1 from logical_date where logical_date_type='B' :4/23/2016
  
  SELECT TO_DATE((select logical_date -1 from logical_date 
  where logical_date_type='B'),'DD/MM/YYYY HH24:MI:SS') FROM DUAL;
  </code></pre>
  
  <p>This Query returns <code>4/23/0016</code>.</p>
  
  <p>How do I get the format given by TO_CHAR using TO_DATE ??</p>