jonnyw6969 Posted February 26, 2008 Share Posted February 26, 2008 Hi all, Im trying to display a date and add 6 months to it. The date is stored like "2008-02-03 17:47:18" in the database. I also dont want to display it if the date has already pasted. Any ideas? Many thanks jon Link to comment https://forums.phpfreaks.com/topic/93133-adding-6-months-to-a-date/ Share on other sites More sharing options...
aschk Posted February 26, 2008 Share Posted February 26, 2008 If you're using MySQL SELECT date FROM <table name here> WHERE date >= DATE_ADD(`date`, "INTERVAL 6 MONTHS"); Link to comment https://forums.phpfreaks.com/topic/93133-adding-6-months-to-a-date/#findComment-477152 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.