Get startedGet started for free

Working with DATEFROMPARTS()

In this lesson, you also learned how to combine different parts of a date, which are in separate columns into one.

In the paper_shop_daily_sales table, the columns year_of_sale, month_of_sale, and day_of_sale, store the different values of a date.

| product_name | units | year_of_sale | month_of_sale | day_of_sale |
|--------------|-------|--------------|---------------|-------------|
| notebooks    | 2     | 2019         | 1             | 1           |
| notebooks    | 3     | 2019         | 5             | 12          |
| ...          | ...   | ...          | ...           | ...         |

You need to combine all these columns into one, by using the DATEFROMPARTS() function.

This exercise is part of the course

Cleaning Data in SQL Server Databases

View Course

Hands-on interactive exercise

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

SELECT 
	product_name,
	units,
    -- Use the function to concatenate the different parts of the date
	___(
      	___, 
      	month_of_sale, 
      	___) AS complete_date
FROM paper_shop_daily_sales
Edit and Run Code