SQL - Date & Time

SELECT NOW() AS now, DATE_ADD(CURDATE(), INTERVAL 7 DAY) AS next_week;

SELECT SYSDATETIME() AS now, DATEADD(DAY, 7, CAST(GETDATE() AS date)) AS next_week;

SELECT datetime('now') AS now, date('now','+7 day') AS next_week;