Date and time functions

This lesson uses the unmodified DDI_SQL_Training dataset v1.0.0 on SQL Server 2019 or later. Calculate dates and date-part boundaries from stored dates.

Run the example

SELECT TOP (3) OrderID, OrderDate,
       DATEADD(day, 7, OrderDate) AS FollowUpDate
FROM dbo.Orders
ORDER BY OrderID;

Read it step by step

1. OrderDate is a date, not a timestamp.
2. DATEADD(day, 7, OrderDate) calculates a date seven days later.
3. ORDER BY OrderID makes the selected first three orders repeatable.

Check the result

FollowUpDate is calculated at query time; it is not a stored column.

Practice

Show the month-end date for Orders 1 through 3 using EOMONTH.

SELECT OrderID, EOMONTH(OrderDate) AS MonthEnd
FROM dbo.Orders
WHERE OrderID BETWEEN 1 AND 3
ORDER BY OrderID;