After N days in MySQL
Simply Use INTERVAL function in MySQL to get the date after N days
Syntax
SELECT NOW(), NOW()+INTERVAL 180 DAY;
prints
2012-08-03 10:12:13 20 | 2013-01-30 10:12:13 20
eg: To Insert into DB table use
INSERT INTO myTable (signup_date, exp_date) VALUES (NOW(), NOW() + INTERVAL 180 DAY);
Date Time Interval in MySQL
