title: PostgreSQL: how to convert from Unix epoch to date?
body: <p>The statement gives me the date and time. </p>
  
  <p>How could I modify the statement so that it returns only the date (and not the time)?</p>
  
  <pre><code>SELECT to_timestamp( TRUNC( CAST( epoch_ms AS bigint ) / 1000 ) );
  </code></pre>