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.
What you'll learn
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.
Table of contents
- 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
- 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
About the author
Scott is a statistical computer programmer specializing in SAS and SQL, but has learned many other languages such as Java, Android, C#, C, PL/SQL, R, and SPSS to name a few. His personal website, sheepsqueezers.com, features documents and presentations on a variety of topics he has learned over the years. Scott is also the author of "Android from A to D," which is his take on how a newbie should be taught Android programming, as well as "Poor Man's Data Dictionary," which describes how to quickl... more