lalabored Posted January 3, 2008 Share Posted January 3, 2008 I need a query that deletes rows with dates that have already passed. I'm storing dates in the future in my MySql database and I want the rows to be deleted when those dates have passed, how so I make a query that does that? I tried this... DELETE FROM mytable WHERE TIME_TO_SEC(SUBTIME(release_date,NOW())) <= 0 But it doesn't work so now I'm stuck, please help me. Link to comment https://forums.phpfreaks.com/topic/84241-solved-a-query-that-deletes-rows-with-dates-that-have-already-passed/ Share on other sites More sharing options...
lalabored Posted January 3, 2008 Author Share Posted January 3, 2008 Nevermind... I figured it out, I never knew you were able to compare dates using the greater than and less than signs ^^;; Link to comment https://forums.phpfreaks.com/topic/84241-solved-a-query-that-deletes-rows-with-dates-that-have-already-passed/#findComment-429012 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.