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