DATE_ADD

1
SELECT
2
  CURRENT_DATE as today,
3
  CURRENT_DATE + INTERVAL '7 days' as next_week,
4
  CURRENT_DATE + INTERVAL '30 days' as next_month;

1
SELECT
2
  invoice_id,
3
  invoice_date,
4
  invoice_date + INTERVAL '30 days' as due_date
5
FROM invoices;

1
SELECT
2
  subscription_start,
3
  subscription_start + INTERVAL '1 year' as annual_renewal,
4
  subscription_start + INTERVAL '1 month' as monthly_renewal
5
FROM subscriptions;

1
SELECT NOW() + INTERVAL '1 month 15 days 2 hours' as future_time;