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.

Este ejercicio forma parte del curso

Functions for Manipulating Data in SQL Server

Ver curso

Instrucciones del ejercicio

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.

Ejercicio interactivo práctico

Prueba este ejercicio completando el código de muestra.

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;

Editar y ejecutar código