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? 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 Link to comment https://forums.phpfreaks.com/topic/131376-loop-problem/#findComment-682309 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.