Expanded Library

Introduction to Dates and Times in SQL Server

by Scott Hecht

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.

Preview this course

What you'll learn

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.

Table of contents

Introduction
17mins
Quick Start Guide
11mins
DATE Data Type
16mins
TIME Data Type
15mins
SMALLDATETIME Data Type
24mins
DATETIME and DATETIME2 Data Types
20mins
String Literals
17mins
Conversion Functions
23mins
Additional Functions
15mins
Date/Time Manipulations
27mins

About the author

Scott Hecht

Scott is a statistical computer programmer specializing in SAS and SQL, but has learned many other languages such as Java, Android, C#, C, PL/SQL, R, and SPSS to name a few. His personal website, sheepsqueezers.com, features documents and presentations on a variety of topics he has learned over the years. Scott is also the author of "Android from A to D," which is his take on how a newbie should be taught Android programming, as well as "Poor Man's Data Dictionary," which describes how to quickl... more

See more courses by Scott Hecht
Ready to upskill? Get started