title: how to parse time and date correctly
body: <p>im having some issues when trying to parse date/time from this csv</p>
  <pre><code>NAME                 LATITUDE   LONGITUDE   DATE   REPORT_TYPE   SOURCE   DailyAverageWindSpeed   DailyPrecipitation
  WICHITA FALLS MUNICIPAL AIRPORT TX US   33.9786   -98.4928   2020-07-01T00:52:00   FM-15   7      
  WICHITA FALLS MUNICIPAL AIRPORT TX US   33.9786   -98.4928   2020-07-01T01:52:00   FM-15   7      
  WICHITA FALLS MUNICIPAL AIRPORT TX US   33.9786   -98.4928   2020-07-01T02:52:00   FM-15   7      
  WICHITA FALLS MUNICIPAL AIRPORT TX US   33.9786   -98.4928   2020-07-01T03:52:00   FM-15   6      
  </code></pre>
  <p>This is the code i have so far.</p>
  <pre><code>X2509750 &lt;- read_csv(&quot;weather.csv&quot;, 
                       col_types = cols(STATION = col_skip(), 
                                        ELEVATION = col_skip(), 
                                        DATE = col_datetime(format = &quot;%Y-%m-%d.%H:%M:%S&quot;)))
  
  Warning: 305532 parsing failures.
  row  col                    expected              actual          file
    1 DATE date like %Y-%m-%d.%H:%M:%S 2020-07-01T00:52:00 'weather.csv'
    2 DATE date like %Y-%m-%d.%H:%M:%S 2020-07-01T01:52:00 'weather.csv'
  </code></pre>