About MySQL's date selection problem

My Database Time field name is create_time , type is TimeStamp type

Now want to get yesterday's data ~ For example the time in the data is2016-06-15 03:28:07
I used the following statement
TO_DAYS(NOW()) - TO_DAYS(create_time) <= 1

Current computer time is2016-06-15 13:45:12

The data can still be displayed, it should not be found out ah ... It should be reasonable to find out the data of June 14, 2016.
Why is this sentence useless?

Reply content:

My Database Time field name is create_time , type is TimeStamp type

Now want to get yesterday's data ~ For example the time in the data is2016-06-15 03:28:07
I used the following statement
TO_DAYS(NOW()) - TO_DAYS(create_time) <= 1

Current computer time is2016-06-15 13:45:12

The data can still be displayed, it should not be found out ah ... It should be reasonable to find out the data of June 14, 2016.
Why is this sentence useless?

Why is it less than or equal to 1, yesterday is equal to 1?

The date format you saved is a timestamp, so you can write it:
To_days (now ())-to_days (From_unixtime (create_time)) = 1

