ADD MONTHS in TERADATA

In Teradata, you can achieve the functionality of adding months to a date using the ADD_MONTHS function. Here's how you can use it:

ADD_MONTHS(date_column, number_of_months)

- date_column: This is the date to which you want to add months.

- number_of_months: This is the number of months to add. It can be positive (to add months) or negative (to subtract months).

Let's see an example to understand how ADD_MONTHS works in Teradata:

Suppose we have a table named sales with a column order_date of type DATE. We want to add 3 months to the order_date.

SELECT ADD_MONTHS(order_date, 3) AS new_order_date

FROM sales;

In this query:

- We use the ADD_MONTHS function to add 3 months to the order_date.

- The result is returned as new_order_date.

This will give you the order dates with 3 months added.

Similarly, you can use a negative value to subtract months from a date. For example, to subtract 6 months from the order_date:

SELECT ADD_MONTHS(order_date, -6) AS new_order_date

FROM sales;

This would result in the order dates with 6 months subtracted.