Multiple choice technology databases

What will be the result of the following SELECT statement SELECT 2000/02/25 + 4

  1. 2000/02/29

  2. 2000/03/01

  3. 44

  4. An error is generated. A DATETIME value and an INT value cannot be added together. Use the DATEADD function for this purpose.

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The expression 2000/02/25 is interpreted as integer division (2000 divided by 2 divided by 25), not as a date. 2000/2 = 1000, then 1000/25 = 40. So 40 + 4 = 44. To add days to a date, you must use the DATEADD function with a proper DATETIME value.