title: Import date time into Oracle DB using SQL Developer format- "6/26/2018 12:41:00 PM"
body: <p>I am trying to import data from CSV file in to Oracle Table.</p>
  
  <p>One of the column is DATETIME,
  with an example value- "<strong>6/26/2018  12:41:00 PM</strong>"
  (With 2 spaces between date and time)</p>
  
  <p>In Data Import Wizard --> Column Definition --> Data Type </p>
  
  <p>I select "Data Type" as Timestamp.</p>
  
  <p>What should select in the below fields-
  Size/Precision- ??   (I tried different sizes like 15, 23, 25,50 )
  Format- ??    (I tried various formats- MM/DD/YYYY HH:Mi:SS AM, MM/DD/YYYY HH:Mi:SS)</p>
  
  <p>Please advise.</p>
  
  <p>Thanks!</p>