PHP - Unix时间戳[关闭]

Question

I have this:

$time = time();
SELECT * FROM users WHERE lastlogin>'$time-86000'

How do I select from the database, where the lastlogin has been completed within the last 24 hours?

I also have this:

SELECT * FROM users WHERE signupdate>'$time-86000'

What I wish to archive here is, how do I select from the database, where the last signupdate is within 24 hours

Answer 1

Mysql can handle unix timestamps as well

select * from table where stamp > unix_timestamp() - 24*3600