How to generate a timestamp?

Question

PHP

The server is adding data to the database every 5 minutes.
Each entry contains a value and a time. The time is just a timestamp time();
Record example 1 1521061200.
The dedicated server is in a different time zone. Its time cannot be changed (virtualization conditions). And when viewing the records, I add the time difference.
I have it 5 hours i.e. +18000 seconds.
Now I see entries in my local time.
I need to display entries from the previous day, two days ago, etc. relative to the current date.
For example, today is 03/15/2018 (current date). I need records ending with the previous day.
Those. display all records where the time is less than 03/14/2018 24:00:00.
Generate such a timestamp.
How can I do that?

Answer 1

where `date` < UNIX_TIMESTAMP(CURDATE())