在Oracle SQL中,可以使用以下方法替代ADD_MONTHS
函數:
DATEADD
函數:SELECT DATEADD(MONTH, 3, your_date_column) AS new_date
FROM your_table;
INTERVAL
關鍵字:SELECT your_date_column + INTERVAL '3' MONTH AS new_date
FROM your_table;
DATE_ADD
函數(在MySQL中可用):SELECT DATE_ADD(your_date_column, INTERVAL 3 MONTH) AS new_date
FROM your_table;