Microsoft SQL training exercises | Calculations using dates

Showing exercises 1-3 (out of 3)

Category: SQL
Topic: Calculations using dates
Level: Relatively easy
Course: Introduction to SQL
Exercise: Format each date in a table, then show how long ago it was (in whole years) using DateDiff.

Go to exercise ...

Category: SQL
Topic: Calculations using dates
Level: Average difficulty
Course: Introduction to SQL
Exercise: Show the closest events to your birthday, using DATEDIFF, CONVERT and ABS functions.

Go to exercise ...

Category: SQL
Topic: Calculations using dates
Level: Harder than average
Course: Introduction to SQL
Exercise: Create a query showing the full date in the format: dddd dd mmmm yyyy, using DatePart or DateName, then show all events happening on Friday 13th.

Go to exercise ...

This page has 0 threads Add post