1. Learn
  2. /
  3. Courses
  4. /
  5. Cleaning Data in SQL Server Databases

Exercise

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.

Instructions 1/2

undefined XP
    1
    2
  • Use the DATEFROMPARTS() to concatenate the different parts of the date.