Introduction to Dates and Times in SQL Server
By Scott Hecht
Course info
Course info
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 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
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.