drisate Posted November 4, 2008 Share Posted November 4, 2008 Hey guys. I have a database with rows that contains a date in this format 2008-11-04 12:53:18 I need to select every rows where the date is latter then 30 days. What would be the SQL querry? Quote Link to comment https://forums.phpfreaks.com/topic/131376-loop-problem/ Share on other sites More sharing options...
Barand Posted November 4, 2008 Share Posted November 4, 2008 do you mean SELECT ... WHERE date > CURDATE() - INTERVAL 30 DAY Quote Link to comment https://forums.phpfreaks.com/topic/131376-loop-problem/#findComment-682309 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.