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

Exercise

Correctly applying different date functions

It's time to combine your knowledge on date functions!

In this exercise, you are going to extract information about each voter and the first time they voted. In the voters table, the date of the first vote is stored in the first_vote_date column.

You will use several date functions, like: DATENAME(), DATEDIFF(), YEAR(), GETDATE().

Instructions 1/4

undefined XP
    1
    2
    3
    4
  • Extract the weekday from the first_vote_date.