Azu Posted March 11, 2007 Share Posted March 11, 2007 I have some tables and there is a time field in them that is generated by now() and I want to select all of the data that are recent select id from news where (date()-time)<60 That should select all of them that are less then 60 seconds old But it never works, just returns false over and over no matter what doesn't even give me an error it just doesn't work. Please tell me why it's not working and how I can fix it Quote Link to comment https://forums.phpfreaks.com/topic/42265-solved-where-datetime-is-recent/ Share on other sites More sharing options...
Barand Posted March 11, 2007 Share Posted March 11, 2007 WHERE date > NOW() - INTERVAL 60 seconds Quote Link to comment https://forums.phpfreaks.com/topic/42265-solved-where-datetime-is-recent/#findComment-205046 Share on other sites More sharing options...
Azu Posted March 13, 2007 Author Share Posted March 13, 2007 Thanks Quote Link to comment https://forums.phpfreaks.com/topic/42265-solved-where-datetime-is-recent/#findComment-206011 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.