In SQL Server and Microsoft Access,to add a specific number of months to a date,use the ____ function.
A)MONTHS
B)DATEADD()
C)ADD_MONTHS
D)CALC_MONTHS

Question

In SQL Server and Microsoft Access,to add a specific number of months to a date,use the ____ function.
A)MONTHS
B)​DATEADD()
C)ADD_MONTHS
D)​CALC_MONTHS

Quizplus · Accepted Answer

The correct function to add a specific number of months to a date in SQL Server and Microsoft Access is DATEADD(). This function allows you to add or subtract a specified number of intervals (such as months, days, or years) to a given date. Therefore, the most appropriate choice is B.

In SQL Server and Microsoft Access,to Add a Specific Number