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