title: String to date in Oracle with milliseconds
body: <p>I want to convert the follow string to date:</p>
  
  <pre><code>2004-09-30 23:53:48,140000000
  </code></pre>
  
  <p>I tried:</p>
  
  <pre><code>to_date('#', 'YYYY-MM-DD HH24:MI:SS,FF9')
  </code></pre>
  
  <p>But <a href="http://en.wikipedia.org/wiki/PL/SQL" rel="noreferrer">PL/SQL</a> keep throwing this error:</p>
  
  <pre><code>ORA-01821: date format not recognized.
  </code></pre>
  
  <p>FF9 is incorrect for Oracle, any suggestion? </p>