title: ORA-01722 INVALID NUMBER in oracle
body: <p>I am getting invalid number error message while executing the below select statement.Can any one have an idea about the issue..Please let me know.</p>
  
  <pre><code>select TO_DATE(TO_CHAR('2015/01/22 00:00:00','YYYY/MM/DD'),'YYYY/MM/DD')
  </code></pre>
  
  <p>actually i want oracle standard date format without time stamp for this date '2015/01/22 00:00:00'</p>