title: What is the equivalent of trunc to get a date from timestamp in Snowflake?
body: <p>My org is in the process of transitioning from Redshift to Snowflake and I would like to ask if there is a neater way of truncating a timestamp field to extract just the date out of it as I would do it in Redshift. </p>
  
  <p>Current best Snowflake query</p>
  
  <p><code>select cast (date_trunc('day',max(my_timestamp)) as date) from my_table</code></p>
  
  <p>Equivalent Redshift query </p>
  
  <p><code>select trunc(my_timestamp) from my_table</code> </p>
  
  <p>Surely it shouldn't have to be this ugly? </p>
  
  <p>Thanks!</p>