title: Copy command unable to copy Date into Redshift
body: <p>I am trying to insert rows like:</p>
  
  <pre><code>2016/02/03,name,12345,34,...
  </code></pre>
  
  <p>I am trying to copy a S3 file like so</p>
  
  <pre><code>copy events
  from 's3://dailyevents/eventdata/l/'' 
  credentials 'aws_access_key_id=&lt;access-key-id&gt;;aws_secret_access_key=&lt;secret-access-key&gt;'
  CSV 
  DATEFORMAT AS 'YYYY/MM/DD';
  </code></pre>
  
  <p>However I am getting a type mismatch error as its interpreting 2016/02/03 as 3 separate values. </p>
  
  <pre><code>Invalid digit, Value 'n', Pos 3, Type: Integer
  </code></pre>
  
  <p>How can I get it to parse the first column as the date format?</p>