How do I return a full-day post on the date of the first post before a specific timestamp?

Title

Database dates are stored using PHP (10-bit) timestamp
A full-day post data for the date on which the first post is to be requested based on the timestamp
How can I get it?

Table name Posts
Timestamp created int (10)

Reply content:

Title

Database dates are stored using PHP (10-bit) timestamp
A full-day post data for the date on which the first post is to be requested based on the timestamp
How can I get it?

Table name Posts
Timestamp created int (10)

SELECT @d := created FROM posts WHERE created < 1234567890  ORDER BY created DESC LIMIT 0, 1;SELECT * FROM posts WHERE created < @d AND created >= (@d - @d % (24*60*60));

