Arithmetic operations with dates

In this exercise, you will perform arithmetic operations on dates in two different ways: using the arithmetic operators ("+" and "-") and also using the DATEDIFF() function. You will use these variables:

DECLARE @date1 datetime = '2018-12-01';
DECLARE @date2 datetime = '2030-03-03';

Create a SELECT statement, in which to perform the following operations:

Subtract @date1 from @date2.
Add @date1 to @date2.
Using DATEDIFF(), calculate the difference in years between the results of the subtraction and the addition above.

What is the result returned by the DATEDIFF() function?

คำตอบที่เป็นไปได้

0 years

238 years

261 years

23 years

Exercises

Arithmetic operations with dates

คำแนะนำ

คำตอบที่เป็นไปได้

.css-6su6fj{-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;}Exercises

คำแนะนำ

คำตอบที่เป็นไปได้

Exercises