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
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
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 47m
Apr 15, 2014
Introduction to Dates and Times in SQL Server
Intermediate
2h 58m
Jan 14, 2014
More courses by Scott Hecht