1. Learn
    2. /
  2. Courses
    3. /
  3. Functions for Manipulating Data in SQL Server

Exercise

Generating descriptive date parts

DATENAME() is an interesting and easy to use function. When you create reports, for example, you may want to show parts of a date in a more understandable manner (i.e. January instead of 1). This is when the DATENAME() function proves its value. This function will return a string value with a description of the date part you are interested in.

In this exercise, you will become familiar with DATENAME(), by using it to retrieve different date parts. You will work with the first_vote_date column from the voters table.

Instructions 1/3

undefined XP
  • 1

    Select information from the voters table, including the name of the month when they first voted.

  • 2

    Select information from the voters table, including the day of the year when they first voted.

  • 3

    Select information from the voters table, including the day of the week when they first voted.