operation with date and deadlines SQL_SERVER

Question

I have a table in the comic book that has a column called term.

in that column I have the deadline information in months ex.: 10, 6, 12, 14....

i would need to calculate to know the final date of each term.

in excel I would use:

=data(ano;mes+prazo;dia)

and it would bring the date relating to the last payment of this term.

how to do in sql?

Answer 1

In sql you could use the DATEADD function. It has the following parameters:

DATEADD (part of date, number to add , date )

In your case DATEADD(Month (Your deadlines are defined in months);deadline;)

Ex:

select DATEADD(month,5,GETDATE())

select DATEADD(month,5,'01/01/2021')

I recommend reading the documentation below:

https://docs.microsoft.com/pt-br/sql/t-sql/functions/date-and-time-data-types-and-functions-transact-sql?view=sql-server-ver15