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
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
Description
Course info
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
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
More courses by Scott Hecht