Course
Skills Expanded
Introduction to Dates and Times in SQL Server
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.
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
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