title: Amazon Athena - Converting Timestamp to Date?
body: <p>Looking at the <a href="https://prestodb.io/docs/0.172/functions/datetime.html" rel="noreferrer">Date/Time Athena documentation</a>, I don't see a function to do this, which surprises me. The closest I see is <code>date_trunc('week', timestamp)</code> but that results in something like <code>2017-07-09 00:00:00.000</code> while I would like the format to be <code>2017-07-09</code></p>
  
  <p>Is there an easy function to convert a timestamp to a date?</p>