title: Format int as date in presto SQL
body: <p>I have an integer date column "date_created" storing values like...</p>
  
  <pre><code>20180527, 20191205, 20200208
  </code></pre>
  
  <p>And am wondering what the best way to parse as a date is so I could do something like this in a query...</p>
  
  <pre><code>select * from table where formatted(date_created) &gt; formatted(date_created) - 90
  </code></pre>
  
  <p>(to return everything within the last 90 days)</p>
  
  <p>I've found some similar examples that convert from date ints representing seconds or milliseconds, but none where the columns are essentially date strings stored as integers.</p>
  
  <p>Appreciate any thoughts on the best way to achieve this</p>