Modifying the value of a date

Adding different date parts to a date expression proves to be useful in many scenarios. You can calculate, for example:

The delivery date of an order, by adding 3 days to the order date
The dates when a bonus is received, knowing that they are received every 3 months, starting with a certain date.

In SQL Server, you can use DATEADD() for adding date parts to a date. In this exercise, you will get familiar with this function.

แบบฝึกหัดนี้เป็นส่วนหนึ่งของหลักสูตร

Functions for Manipulating Data in SQL Server

ลองทำแบบฝึกหัดนี้โดยเติมโค้ดตัวอย่างนี้ให้สมบูรณ์

SELECT 
	first_name,
	birthdate,
    -- Add 18 years to the birthdate
	___(___, ___, ___) AS eighteenth_birthday
  FROM voters;