Adds n months to a date.
Syntax
ADD_MONTHS(date, n)Example
Enter values below to update the example in real time.
subscription_id→start_date→expire_date→subscriptions→-- 3개월 후 만료일 계산
SELECT subscription_id,
ADD_MONTHS(start_date, 3) AS expire_date
FROM subscriptions;