Working with Date and Time Datatypes in SQL Server

Home/Development, SQL Server/Working with Date and Time Datatypes in SQL Server

Working with Date and Time Datatypes in SQL Server

$4.00

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

Categories: ,

Description

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

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

Content missing