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.
Este exercício faz parte do curso
Cleaning Data in SQL Server Databases
Exercício interativo prático
Experimente este exercício completando este código de exemplo.
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