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.
Course info
Rating
(98)
Level
Intermediate
Updated
Jan 14, 2014
Duration
2h 58m
Table of contents
Introduction
Introduction 0m Course Contents 1m Module Contents 1m Database Version 1m Data Used in Course 1m SELECT w/o FROM 1m Missing Topics 1m DATEFORMAT Warning 3m DATEFIRST and @@DATEFIRST 3m Precision of Numeric Constants 3m Precedence 2m Summary 0m
Quick Start Guide
Introduction 0m Module Contents 1m Data Types 4m Congruence 2m String Literals 1m Conversion Functions 1m Additional Functions 1m Summary 1m
DATE Data Type
Introduction 0m Module Contents 1m The DATE Data Type 3m Storage 2m Initialization 4m Operations 4m Summary 2m
TIME Data Type
Introduction 0m Module Contents 1m The TIME Data Type 5m Storage 1m Initialization 3m Operations 3m Summary 2m
SMALLDATETIME Data Type
Introduction 0m Module Contents 1m The SMALLDATETIME Data Type 8m Storage 1m Initialization 3m Operations 9m Summary 2m
DATETIME and DATETIME2 Data Types
Introduction 0m Module Contents 1m The DATETIME/DATETIME2 Data Types 5m Storage 1m Initialization 3m Operations 7m Summary 3m
String Literals
Introduction 0m Module Contents 1m A Literal Overview 3m The DATE Literal 3m The TIME Literal 2m The SMALLDATETIME Literal 2m The DATETIME Literal 2m The DATETIME2 Literal 2m Summary 2m
Conversion Functions
Introduction 0m Module Contents 1m The DATEFROMPARTS() Function 1m The TIMEFROMPARTS() Function 2m The SMALLDATETIMEFROMPARTS() Function 1m The DATETIMEFROMPARTS() Function 2m The DATETIME2FROMPARTS() Function 2m The CAST() Function 2m The CONVERT() Function 3m The FORMAT() Function 7m Summary 2m
Additional Functions
Introduction 0m Module Contents 1m DAY()/MONTH()/YEAR() Functions 1m EOMONTH() Function 2m GETDATE()/CURRENT_TIMESTAMP 1m SYSDATETIME() Function 1m DATEPART()/DATENAME() Functions 3m DATEADD() Function 2m DATEDIFF() Function 2m Summary 2m
Date/Time Manipulations
Introduction 0m Module Contents 1m Elementary Reminders 1m Adding To and Subtracting From 3m Converting To and From 3m Converting to Numeric Values 6m Zeroing Out the Date or Time 3m First Days and Last Days 4m Next Monday 4m Summary 2m
Description
Course info
Rating
(98)
Level
Intermediate
Updated
Jan 14, 2014
Duration
2h 58m
Description

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.

About the author
Scott Hecht
About the author

Scott is a statistical computer programmer specializing in SAS and SQL. An admitted dilettante, Scott occupies his time learning various programming languages such as Java, Android, C#, C, PL/SQL, R, SPSS, to name a few. Scott becomes visibly upset if you don't line up your code syntax!

More from the author
SQL Data Wrangling in Oracle: Table Data
Intermediate
5h 18m
Nov 27, 2014
Optimizing SQL Queries in Oracle
Intermediate
3h 47m
Apr 15, 2014
More courses by Scott Hecht

You're the smartest person in the room

PROVE IT

Your team won't just close the skills gap

THEY'LL HURDLE IT