How to select records that were created for some date if the creation date is stored in a timestamp?

Question

PostgreSQL

How, besides sampling in the interval between 2016-06-01 00:00:00 and 2016-06-01 23:59:59, can you select records for 2016-06-01 if the creation date is stored in a timestamp?

Answer 1

The interval selection will work on the index on this field, which often already exists and is still needed for other queries.
Other options are possible - explicit casting to the date ::date, standard datetime processing functions date_trunc, date and any stable storage. And these methods can also work on an index, but a specially created functional index just for this expression.