Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

Introduction to Dates and Times in SQL Server

via Pluralsight

Overview

The Introduction to Dates and Times in SQL Server course details how to use the date, time, smalldatetime, datetime and datetime2 data types as well as the many date- and time-related functions available to the SQL programmer.

The Introduction to Dates and Times in SQL Server course details how to use the date, time, smalldatetime, datetime and datetime2 data types as well as the many date- and time-related functions available to the SQL programmer such as DATEPART(), DATEFROMPARTS(), DATEADD(), as well as many others.

Syllabus

  • Introduction 17mins
  • Quick Start Guide 10mins
  • DATE Data Type 15mins
  • TIME Data Type 13mins
  • SMALLDATETIME Data Type 22mins
  • DATETIME and DATETIME2 Data Types 19mins
  • String Literals 15mins
  • Conversion Functions 21mins
  • Additional Functions 15mins
  • Date/Time Manipulations 27mins

Taught by

Scott Hecht

Reviews

4.1 rating at Pluralsight based on 101 ratings

Start your review of Introduction to Dates and Times in SQL Server

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.