SQL exercises on CALCULATIONS USING DATES

This page lists the 4 exercises about Calculations using dates in SQL on our website:

Software: SQL
Version: Any version of SQL Server
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 ...

Software: SQL
Version: Any version of SQL Server
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 ...

Software: SQL
Version: Any version of SQL Server
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 ...

Software: SQL
Version: Any version of SQL Server
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 ...

You can search our full list of SQL exercises here, or why not have a look at our other SQL training resources?

This page has 0 threads Add post