title: TO_DATE problems
body: <p>I have the following in my SQL where clause. This is running against an Oracle database. The <code>sc_dt</code> field is defined in the db as a date field.</p>
  
  <pre><code>sc_dt = TO_DATE('2011-11-03 00:00:00.0', 'YYYY-MM-DD')
  </code></pre>
  
  <p>produces the following error <code>"date format picture ends before converting entire input string"</code></p>
  
  <p>When I try to account for the fractional seconds (<code>.0</code> in this case) with the following, I get the following error.</p>
  
  <pre><code>sc_dt = TO_DATE('2011-11-03 00:00:00.0', 'YYYY-MM-DD HH24:MI:SS.FF')
  </code></pre>
  
  <p>produces the following error <code>"date format not recognized"</code></p>
  
  <p>I'm really just assuming that I need the <code>.FF</code> to account for the <code>.0</code> in the "from" string. I've also tried <code>.FF1</code>, <code>.FF2</code>, ..., <code>.FF9</code> with the same results (I'm grasping at straws at this point).</p>
  
  <p>As far as I can see, the <code>sc_dt</code> field always has the month/day/year portion populated (and not the hour/minute/second portion).</p>
  
  <p>I'm debugging a java program which is executing the above SQL as a prepared statement with the <code>2011-11-03 00:00:00.0</code> value.</p>
  
  <p>How can I get around this?</p>