Selecting UNIX time within the SQL statment?
Posted: Sun Sep 03, 2006 7:17 pm
Hi
i know im close to what i want but cant get it right
here is what i have, user logs in and time() unix timestam is recirded, now i wan to find out who loged in within last 30 sec so i do:
SELECT * FROM users WHERE timestamp >= ROM_UNIXTIME(0)-30;
But that doesnt work...
can some one corect me? thanks!
i know im close to what i want but cant get it right
here is what i have, user logs in and time() unix timestam is recirded, now i wan to find out who loged in within last 30 sec so i do:
SELECT * FROM users WHERE timestamp >= ROM_UNIXTIME(0)-30;
But that doesnt work...