title: How to force DateTime field in Quicksight on string column?
body: <p>I have a data set that has dates like so:</p>
  
  <p>datetimecreated
  2019-09-14 06:06:15.863383
  2019-09-14 06:06:16.863385</p>
  
  <p>When I go to edit my data set and force column <code>datetimecreated</code> into datatype date time, I get error: </p>
  
  <pre><code>Known date formats were not detected in this data. Provide a date format to transform this data into a known date format.
  </code></pre>
  
  <p>The data format I am trying to pass is this:</p>
  
  <pre><code>yyyy-MM-dd HH:mm:ss.ffffff
  </code></pre>
  
  <p>What am I doing wrong that this can not be detected as date field by Quicksight? </p>
  
  <p>I've even tried this format: </p>
  
  <pre><code>yyyy-MM-dd HH:mm:ss
  </code></pre>
  
  <p>get same error as above. </p>