Copy command unable to copy Date into Redshift
<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>