title: Skip Characters in Oracle TO_DATE function
body: <p>I'm importing data that has SQL Server formatted dates in a .tsv (<code>yyyy-mm-dd hh24:mi:ss.mmm</code>) into an Oracle database using SQL Developer's Import Data wizard.</p>
  
  <p>How can I ignore the <code>.mmm</code> characters for importing them into a DATE column? I cannot seem to find an answer to this; I get that DATE columns don't hold milliseconds, but why can't I ignore specific patterns in the TO_DATE call?</p>
  
  <p>Also note that because I'm not generating the TO_DATE calls, I cannot <code>SUBSTRING</code> or otherwise manipulate the .tsv's value during the import.</p>
  
  <p><img src="https://i.stack.imgur.com/5kXsL.png" alt="Import Data Wizard - Date"></p>