Microsoft SQL training exercises | Calculations using dates

Showing exercises 1-4 (out of 4)

Category: SQL
Topic: Calculations using dates
Level: Relatively easy
Course: Introduction to SQL
Exercise: Combine the YEAR, CONVERT and FORMAT functions to show events in your year of birth.

Go to exercise ...

Category: SQL
Topic: Calculations using dates
Level: Average difficulty
Course: Introduction to SQL
Exercise: Use the DATEDIFF and the ABS functions to list the events in order of closeness to when you were born.

Go to exercise ...

Category: SQL
Topic: Calculations using dates
Level: Average difficulty
Course: Introduction to SQL
Exercise: Use the DATENAME and DATEPART functions to show events taking place on Friday 13th of any month/year.

Go to exercise ...

Category: SQL
Topic: Calculations using dates
Level: Harder than average
Course: Introduction to SQL
Exercise: Display full dates, including the correct suffix (1st, 2nd, 3rd, etc).

Go to exercise ...

This page has 0 threads Add post