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 46m
Apr 15, 2014
More courses by Scott Hecht
Section Introduction Transcripts
Section Introduction Transcripts

Introduction
Hello and welcome to the Introduction to Dates and Times in SQL Server. My name is Scott Hecht and in this course I'll be discussing the Date and Time-related data types, such as DATE, TIME, SMALLDATETIME, DATETIME, and DATETIME2, how to work with them, as well as showing you all the functions you can use to manipulate dates and times. So let's get started.

Quick Start Guide
Hello and welcome back to the Introduction to Dates and Times in SQL Server. My name is Scott Hecht, and in this module, I'd like to present an overview of what I'll be discussing in the following modules. I like to think of this module as a Quick Start Guide to Dates and Times. So let's get started.

DATE Data Type
Hello and welcome back to the Introduction to Dates and Times in SQL Server. My name is Scott Hecht, and in this module, I'd like to concentrate solely on the DATE Data Type, and explain how to work with it. So, let's get started.

TIME Data Type
Hello and welcome back to the Introduction to Dates and Times in SQL Server. My name is Scott Hecht, and in this module, I'd like to concentrate on the TIME Data Type, and explain how to work with it. So let's get started.

SMALLDATETIME Data Type
Hello and welcome back to the Introduction to Dates and Times in SQL Server. My name is Scott Hecht, and in this module, I'd like to concentrate on the SMALLDATETIME Data Type and explain how to work with it. So, let's get started.

DATETIME and DATETIME2 Data Types
Hello and welcome back to the Introduction to Dates and Times in SQL Server. My name is Scott Hecht, and in this module, I'd like to concentrate on the DATETIME and DATETIME2 Data Types, and explain how to work with them. So let's get started.

String Literals
Hello and welcome back to the Introduction to Dates and Times in SQL Server. My name is Scott Hecht, and in this module, I'd like to discuss in detail the String Literals associated with our five DATE and TIME-related Data Types and explain how to use them. So let's get started.

Conversion Functions
Hello and welcome back to the Introduction to Dates and Times in SQL Server. My name is Scott Hecht, and in this module, I'd like to go over the DATE and TIME-related Conversion Functions in detail. So let's get started.

Additional Functions
Hello and welcome back to the Introduction to Dates and Times in SQL Server. My name is Scott Hecht, and in this module, I'd like to talk about the additional useful functions you can use with dates and times. So let's get started.

Date/Time Manipulations
Hello and welcome back to the Introduction to Dates and Times in SQL Server. My name is Scott Hecht, and in this module, I'd like to discuss some interesting manipulations on Date and Times you can do in SQL Server. So let's get started.