Build dates from parts
The DATEFROMPARTS() function allows us to turn a series of numbers representing date parts into a valid DATE data type. In this exercise, we will learn how to use DATEFROMPARTS() to build dates from components in a calendar table.
Although the calendar table already has dates in it, this helps us visualize circumstances in which the base table has integer date components but no date value, which might happen when importing data from flat files directly into a database.
Bu egzersiz
Time Series Analysis in SQL Server
kursunun bir parçasıdırUygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
-- Create dates from component parts on the calendar table
SELECT TOP(10)
DATEFROMPARTS(c.___, c.___, c.___) AS CalendarDate
FROM dbo.Calendar c
WHERE
c.CalendarYear = 2017
ORDER BY
c.FiscalDayOfYear ASC;