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