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.
Latihan ini adalah bagian dari kursus
Cleaning Data in SQL Server Databases
Latihan interaktif praktis
Cobalah latihan ini dengan menyelesaikan kode contoh berikut.
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