Build dates and times from parts
SQL Server has several functions for generating date and time combinations from parts. In this exercise, we will look at DATETIME2FROMPARTS() and DATETIMEFROMPARTS().
Neil Armstrong and Buzz Aldrin landed the Apollo 11 Lunar Module--nicknamed The Eagle--on the moon on July 20th, 1969 at 20:17 UTC. They remained on the moon for approximately 21 1/2 hours, taking off on July 21st, 1969 at 18:54 UTC.
This exercise is part of the course
Time Series Analysis in SQL Server
Exercise instructions
- Build the date and time (using
DATETIME2FROMPARTS()) that Neil and Buzz became the first people to land on the moon. Note the "2" inDATETIME2FROMPARTS(), meaning we want to build aDATETIME2rather than aDATETIME. - Build the date and time (using
DATETIMEFROMPARTS()) that Neil and Buzz took off from the moon. Note that this is for aDATETIME, not aDATETIME2.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
SELECT
-- Mark the date and time the lunar module touched down
-- Use 24-hour notation for hours, so e.g., 9 PM is 21
DATETIME2FROMPARTS(___, ___, ___, ___, ___, 00, 000, 0) AS TheEagleHasLanded,
-- Mark the date and time the lunar module took back off
-- Use 24-hour notation for hours, so e.g., 9 PM is 21
DATETIMEFROMPARTS(___, ___, ___, ___, ___, 00, 000) AS MoonDeparture;