rdub Posted August 14, 2008 Share Posted August 14, 2008 Need to select records who's number of days between an expiration date and the current date that is between 0 and 90. I have a field in my MySQL database called "expire". How might I accomplish this? Link to comment https://forums.phpfreaks.com/topic/119582-days-between-dates/ Share on other sites More sharing options...
toplay Posted August 14, 2008 Share Posted August 14, 2008 ... WHERE DATEDIFF(CURDATE(), `expire`) BETWEEN 0 AND 90; http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_datediff Link to comment https://forums.phpfreaks.com/topic/119582-days-between-dates/#findComment-616170 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.