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 Quote Link to comment 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"); Quote Link to comment 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.