title: How to filter table to date when it has a timestamp with time zone format?
body: <p>I have a very large dataset - records in the hundreds of millions/billions. </p>
  
  <p>I would like to filter the data in this column - i am only showing 2 records of millions: </p>
  
  <pre><code>arrival_time 
  2019-04-22 07:36:09.870+00
  2019-06-07 09:46:09.870+00
  </code></pre>
  
  <p>How can i filter the data in this column to only the date part? as in I would like to filter where the arrival_time is 2019-04-22 as this would give me the first record and any other records which have the matching date of 2019-04-22?</p>
  
  <p>I have tried to cast the column to timestamp::date = "2019-04-22" but this has been costly and does not work well given i have such vast amounts of records. </p>
  
  <p>sample code is: </p>
  
  <pre><code>select 
  *
  from 
  mytable
  where 
  arrival_time::timestamp::date = '2019-09-30'
  </code></pre>
  
  <p>again very costly if i cast to date format as this will be done before the filtering! </p>
  
  <p>any ideas? I am using postgresql and pgadmin4</p>