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 Quote 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) Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.