Creating a date from parts

While most functions you worked with so far extract parts from a date, DATEFROMPARTS() does exactly the opposite: it creates a date from three numbers, representing the year, month and the day.

The syntax is: DATEFROMPARTS(year, month, day)

You can also use expressions that return numeric values as parameters for this function, like this: DATEFROMPARTS(YEAR(date_expression), MONTH(date_expression), 2)

In this exercise, you will select information from the voters table, including the year and the month of the first_vote_date. Then, you will create a new date column representing the first day in the month of the first vote.

This exercise is part of the course

Functions for Manipulating Data in SQL Server

View Course

Exercise instructions

Select the year of the first vote.
Select the month of the first vote date.
Create a date as the start of the month of the first vote.

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

SELECT 
	first_name,
	last_name,
    -- Select the year of the first vote
   	___(first_vote_date) AS first_vote_year, 
    -- Select the month of the first vote
	___(first_vote_date) AS first_vote_month,
    -- Create a date as the start of the month of the first vote
	___(___, ___, 1) AS first_vote_starting_month
FROM voters;

Edit and Run Code