-- Oracle:SELECT TO_DATE('2012-12-10','YYYY-MM-DD')+7 FROM DUAL;-- SQLServer:SELECT convert(varchar(12),dateadd(day,7,cast('2012-12-10' as datetime)),23); -- MySQL:SELECT DATE_ADD(DATE_FORMAT('2014-10-10','%Y-%m-%d'),INTERVAL 7 DAY);