title: Oracle Database Table Column Timestamp
body: <p>I am trying to create a table in my Oracle Database with the following structure:</p>
  
  <pre><code>CREATE TABLE orderlines(collectionTime TIMESTAMP NOT NULL);
  </code></pre>
  
  <p>An example of a timestamp that will be going in a row is:</p>
  
  <pre><code>20-01-2015 11:33:48-04:00
  </code></pre>
  
  <p>What would be the best datatype to use to store this timestamp?
  TIMESTAMP, or DATE?</p>
  
  <p>Also, what would the format be?</p>
  
  <p>When I tried to import my CSV file containing all of the timestamps, SQL Developer Import Wizard didnt like the formatting. I tried </p>
  
  <pre><code>DD-MM-YYYY HH24:SS:MM-TZ
  </code></pre>