CGRRay Posted October 31, 2006 Share Posted October 31, 2006 I want to select records that have an expiration date of 1 month before the current date on.The query looks something like this:SELECT first_name, last_nameFROM membersWHERE exp_date >The exp_date is stored as a UNIX timestamp.Any help is appreciated. Link to comment https://forums.phpfreaks.com/topic/25741-how-do-i-query-to-get-an-ongoing-range-of-dates/ Share on other sites More sharing options...
fenway Posted October 31, 2006 Share Posted October 31, 2006 WHERE exp_date < NOW() - INTERVAL 1 MONTH Link to comment https://forums.phpfreaks.com/topic/25741-how-do-i-query-to-get-an-ongoing-range-of-dates/#findComment-117554 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.