Introduction to Dates, Times and Intervals in Oracle

The Introduction to Dates, Time and Intervals in Oracle course details how to use the DATE, TIMESTAMP and INTERVAL data types as well as the many date- and time-related functions available to the SQL programmer.
Course info
Rating
(53)
Level
Intermediate
Updated
Dec 6, 2013
Duration
2h 24m
Table of contents
Getting Started
Overview
DATE Data Type
TIMESTAMP Data Type
INTERVAL Data Types
Literals
Conversion Functions
Additional Functions
Description
Course info
Rating
(53)
Level
Intermediate
Updated
Dec 6, 2013
Duration
2h 24m
Description

The Introduction to Dates, Time and Intervals in Oracle course details how to use the DATE, TIMESTAMP and INTERVAL data types as well as the many date- and time-related functions available to the SQL programmer such as TO_DATE(), TO_CHAR(), MONTHS_BETWEEN(), 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
Introduction to Dates and Times in SQL Server
Intermediate
2h 58m
Jan 14, 2014
More courses by Scott Hecht
Section Introduction Transcripts
Section Introduction Transcripts

Getting Started
Hello, and welcome to "Introduction to Dates, Times, and Intervals in Oracle". My name is Scott Hecht and in this course I'll be discussing the date, timestamp, and both interval data types, how to work with them, as well as show you all of the functions you can use to manipulate dates, times, and intervals. Before we begin the course, though, let's go over the course contents. We'll start off with an overview briefly introducing dates, times, and intervals, as well as touch on literals and the date and time-related functions available to the SQL programmer. The modules that follow this overview will go into much more detail. We start off discussing the date, timestamp, and both interval data types. We then move on to a discussion about literals or constants, as they're also known, followed by a discussion of the available conversion functions, as well as additional date and time-related functions available to the SQL programmer.

Overview
Hello, and welcome back to "Introduction to Dates, Times, and Intervals in Oracle". My name is Scott Hecht, and in this module I'd like to present an overview of what I will be discussing in the following modules. I like to think of this module as a quick-start guide to dates, times, and intervals.

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

TIMESTAMP Data Type
Hello and welcome back to the "Introduction to Dates, Times, and Intervals in Oracle". My name is Scott Hecht, and in this module I'd like to concentrate on the timestamp data type and explain how to work with it, so let's get started.

INTERVAL Data Types
Hello, and welcome back to the Introduction to Dates, Times, and Intervals in Oracle. My name is Scott Hecht, and in this module I'd like to concentrate on the INTERVAL data types, there are two of them, and explain how to work with them. So, let's get started.

Literals
Hello. Welcome back to the Introduction to Dates, Times, and Intervals in Oracle. My name is Scott Hecht, and in this module I'd like to talk about the literals, or constants associated with each of the date and time related data types we talked about. So, let's get started.

Conversion Functions
Hello and welcome back to the Introduction to Dates, Times, and Intervals in Oracle. My name is Scott Hecht, and in this module I'd like to talk about the date and time related conversion functions, some of which, like the two-day function, we've already seen. Since these functions make use of format models, we explain that in detail as well. So, let's get started.

Additional Functions
Hello, and welcome back to the Introduction to Dates, Times, and Intervals in Oracle. My name is Scott Hecht, and in this module I'd like to talk about some additional useful date and time related functions, like the ADD_MONTHS function, which allows you to add or subtract months from a date. The MONTHS_BETWEEN function, which computes how many months, including fractional months, that are between two dates, and many more. So, let's get started.