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