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
@date1from@date2. - Add
@date1to@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?
Deze oefening maakt deel uit van de cursus
Functions for Manipulating Data in SQL Server
Praktische interactieve oefening
Zet theorie om in actie met een van onze interactieve oefeningen.
Begin met trainen