ted_chou12 Posted October 24, 2009 Share Posted October 24, 2009 Hi, I wish to grab data that is greater than two days, but the query i attempted doesn't seem to be correct: select * from table where TIMESTAMP(signupdate) < TIMESTAMP(-2days) Thanks, Ted Link to comment https://forums.phpfreaks.com/topic/178868-solved-timestamp-to-get-results-more-than-two-days/ Share on other sites More sharing options...
Mchl Posted October 24, 2009 Share Posted October 24, 2009 Maybe like this? SELECT * FROM table WHERE signupdate < DATE_ADD(NOW(),INTERVAL -2 DAY) Link to comment https://forums.phpfreaks.com/topic/178868-solved-timestamp-to-get-results-more-than-two-days/#findComment-943659 Share on other sites More sharing options...
ted_chou12 Posted October 24, 2009 Author Share Posted October 24, 2009 yeap, i think that's exactly what im looking for Link to comment https://forums.phpfreaks.com/topic/178868-solved-timestamp-to-get-results-more-than-two-days/#findComment-943663 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.