Here is another popular lab from Hands-On-Lab library: Working with Date and Time Datatypes in SQL Server.
This lab focusses on date and time datatypes and functions available in SQL Server and how to effectively use the functions to solve real-world problems. The lab is divided into four exercise. In the first exercise, we will learn about various date and time data types that are available in SQL Server. In the second exercise, we will learn about various date and time functions that are useful while working with date and time data types. In the third exercise, we will learn about the problems in storing Datetime values as VARCHAR. In the fourth and final exercise, we will solve real-world date time calculations with Datetime functions.
Exercise 1: Introduction to Date and Time Datatypes
Exercise 2: Datetime functionsExercise
Exercise 3: Storing Datetime values as VARCHAR
Exercise 4: Working with Datetime functions
SQLMaestros Hands-On-Labs enables the practical way of learning. Each lab document consists of multiple exercises and each exercise consists of multiple tasks. Apart from step-by-step instructions, the HOL document contains images, explanations, observations, notes, tips & tricks to ensure a great learning experience. With each lab, you can practice a specific concept step-by-step. With our HOL documents, you will get hands-on with hundreds of topics in SQL Server & Microsoft Data Platform. Learn More.