title: Can TO_DATE function return a TIMESTAMP?
body: <p>Can, in any form, <code>TO_DATE</code> function return a <code>TIMESTAMP</code>? Example:</p>
  
  <p>I have the following input: <code>'2019-05-31 13:15:25.000000000'</code> 
  I want to have <code>'2019-05-31 13:15:25'</code> as a result using <code>TO_DATE</code> and not <code>TO_TIMESTAMP</code>.</p>
  
  <p>I tried: </p>
  
  <pre><code>select to_date(substr('2019-05-31 13:15:25.000000000', 1, 19), 'YYYY-MM-DD HH24:MI:SS') from dual;
  </code></pre>
  
  <p>But it returns: </p>
  
  <pre><code>31/05/2019
  </code></pre>