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.
Course info
Rating
(98)
Level
Intermediate
Updated
Jan 14, 2014
Duration
2h 58m
Table of contents
Introduction
Quick Start Guide
DATE Data Type
TIME Data Type
SMALLDATETIME Data Type
DATETIME and DATETIME2 Data Types
String Literals
Conversion Functions
Additional Functions
Date/Time Manipulations
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
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