As in postgres to get the records related to the day of a certain timestamp?

Good afternoon.

How to implement takyu thing in postgres:

$timestamp = 2345268712...; (for example, this 2017-10-12 or 2017-10-12 10:22, in both cases you need to pull only those records where $timestamp fits into 2017-10-12)

select from tablename where date_create_stamp ~ ( record?, which relate to the day label <b>$timestamp</b> );
June 14th 19 at 18:12
2 answers
June 14th 19 at 18:14
Solution
Don't know, maybe there are solutions specifically better and I'm not sure that I correctly understand Your question... But if You need to select all the dates without time (TIMESTAMP fields), in PostgreSQL it is working same design as in the other database:
SELECT * FROM table1 WHERE DATE(timestamp_field) = '2017-10-09';
June 14th 19 at 18:16
Solution
Something like:
SELECT *
FROM tablename
WHERE date(date_create_stamp) = date(well, there's your timestamp)

Find more questions by tags PostgreSQL