title: Presto Or Trino, How to parse date with out separator
body: <p>Date is in format as YYYYMMDD eg 20200125= 20200 Jan 25. No Separator found in data.
  How to cast to date time as YY-MM-DD format</p>
  <pre><code>select date_parse( mydate, 'YYYYMMDD') as castDate 
  </code></pre>
  <p><strong>SQL Error [7]</strong>: Query failed (#20220504_161754_00322_m75nu): Invalid format: &quot;20200125&quot;</p>
  <pre><code>date_parse( mydate, '%Y%m%d') as castDate
  </code></pre>
  <p><strong>SQL Error [7]</strong>: Query failed (#20220504_161820_00323_m75nu): Invalid format: &quot;MISSING&quot;</p>