title: Athena date format unable to convert string to date formate
body: <p>tried the below syntax none of them helped to convert a string type column to date</p>
  
  <pre><code>select INVC_,APIDT,APDDT from APAPP100 limit 10
  select current_date, APIDT,APDDT from APAPP100 limit 10
  select date_format( b.APIDT, '%Y-%m-%d') from APAPP100 b
  select CAST( b.APIDT AS date) from APAPP100 b
  select date(b.APIDT) from APAPP100 b
  select convert(datetime, b.APIDT) from APAPP100 b
  select date_parse(b.APIDT, '%Y-%m-%d') from APAPP100 b
  select str_to_date(b.APIDT) from APAPP100 b
  </code></pre>