Introduction to Dates, Times and Intervals in Oracle
By Scott Hecht
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
Introduction and Course Contents
1m
Database Version
1m
Data used in Course
2m
The DUAL Table
1m
Missing Content
1m
Summary
1m
Overview
Introduction
0m
Module Contents
1m
Data Types
4m
Congruence
2m
Literals
1m
Conversion Functions
2m
Additional Functions
1m
Summary
1m
DATE Data Type
Introduction
0m
Module Contents
1m
The DATE Data Type
4m
Storage
2m
Initialization
3m
Operations
8m
Summary
0m
TIMESTAMP Data Type
Introduction
0m
Module Contents
1m
The TIMESTAMP Data Type
5m
Storage
1m
Initialization
3m
Operations
5m
Summary
0m
INTERVAL Data Types
Introduction
0m
Module Contents
1m
The INTERVAL Data Types
6m
Storage
0m
Initialization
3m
Operations
7m
Summary
0m
Literals
Introduction
0m
Module Contents
1m
A Literal Overview
2m
The DATE Literal
4m
The TIMESTAMP Literal
2m
A Warning About Default Formats
4m
The INTERVAL YEAR TO MONTH Literal
4m
The INTERVAL DAY TO SECOND Literal
5m
Summary
1m
Conversion Functions
Introduction
0m
Module Contents
1m
TO_CHAR() Conversion Function
4m
Format Models Introduction
4m
Format Models (YYYY/MM/DD)
1m
Format Models (MONTH/MON)
1m
Format Models (DAY/DY)
1m
Format Models (DDD/D)
1m
Format Models (WW/W)
1m
Format Models (Q/J)
2m
Format Models (DS)
2m
Format Models (DL)
3m
Format Models (HH/HH12/HH24/MI/SS/xFF)
3m
TO_DATE() Conversion Function
1m
TO_TIMESTAMP() Conversion Function
1m
TO_YMINTERVAL() Conversion Function
1m
TO_DSINTERVAL() Conversion Function
1m
NUMTOYMINTERVAL() Conversion Function
1m
NUMTODSINTERVAL() Conversion Function
1m
CAST() Conversion Function
2m
EXTRACT() Conversion Function
2m
Summary
1m
Additional Functions
Introduction
0m
Module Contents
1m
The ADD_MONTHS() Function
2m
The MONTHS_BETWEEN() Function
3m
The NEXT_DAY() Function
1m
The LAST_DAY() Function
1m
The ROUND() Function
3m
The TRUNC() Function
3m
The SYSDATE and CURRENT_DATE Functions
1m
The SYSTIMESTAMP and CURRENT_TIMESTAMP Functions
2m
Summary
0m
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
More courses by Scott Hecht