How to pull out records related to the day of a certain timestamp in postgres?

Question

PostgreSQL

Good afternoon.
How to implement this thing in postgres:

$timestamp = 2345268712...; (например это 2017-10-12 или 2017-10-12 10:22, в обоих случая нужно вытащить записи только те, у который $timestamp вписывается в 2017-10-12)

select from tablename where date_create_stamp ~ ( записи?, которые относятся ко дню метки <b>$timestamp</b> );

Answer 1

I don’t know, maybe there are better solutions and I’m not sure that I understood your question correctly ... But if you need to select all dates without taking into account the time (TIMESTAMP type fields), then the same construction works in PostgreSQL as in other databases :

SELECT * FROM table1 WHERE DATE(timestamp_field) = '2017-10-09';