title: Oracle column with Timestamp(6) data type extract using ssis
body: <p>I am trying to pull an oracle table data into sql server using SSIS. I have a package variable that holds the source query that needs to be fired in the oracle db.I have a data flow task with oledb source(oracle) and oledb destination(sql server).</p>
  
  <p>The oledb source query(variable) is as follows</p>
  
  <pre><code>Select A,B,C 
    From "Table" TT  
   Where C in (Select coalesce(ab,cd) as c 
                 From "Table" T2 
                Where Last_Upd_Dt &gt;= '2018-09-24 12:00:00')
  </code></pre>
  
  <p>The column <code>Last_Upd_Dt</code>  is a <code>TimeStamp(6)</code> with default value of <code>LocalTimeStamp</code> in the source oracle DB</p>
  
  <p>My question is in what format should my input parameter value be so that I dont have to convert the <code>Last_Upd_Dt</code> column to <code>TO_DATE()</code>, <code>TO_CHAR()</code> etc. </p>
  
  <p>If I run that query using SSIS I get </p>
  
  <blockquote>
    <p><strong><em>ORA-01843</em></strong>: <em>not a valid month</em></p>
  </blockquote>