MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Introduction to Dates, Times and Intervals in Oracle

Course Summary

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


  • +

    Course Syllabus

    ● Getting Started
        ◦ Introduction and Course Contents
        ◦ Database Version
        ◦ Data used in Course
        ◦ The DUAL Table
        ◦ Missing Content
        ◦ Summary
    ● Overview
        ◦ Introduction
        ◦ Module Contents
        ◦ Data Types
        ◦ Congruence
        ◦ Literals
        ◦ Conversion Functions
        ◦ Additional Functions
        ◦ Summary
    ● DATE Data Type
        ◦ Introduction
        ◦ Module Contents
        ◦ The DATE Data Type
        ◦ Storage
        ◦ Initialization
        ◦ Operations
        ◦ Summary
    ● TIMESTAMP Data Type
        ◦ Introduction
        ◦ Module Contents
        ◦ The TIMESTAMP Data Type
        ◦ Storage
        ◦ Initialization
        ◦ Operations
        ◦ Summary
    ● INTERVAL Data Types
        ◦ Introduction
        ◦ Module Contents
        ◦ The INTERVAL Data Types
        ◦ Storage
        ◦ Initialization
        ◦ Operations
        ◦ Summary
    ● Literals
        ◦ Introduction
        ◦ Module Contents
        ◦ A Literal Overview
        ◦ The DATE Literal
        ◦ The TIMESTAMP Literal
        ◦ A Warning About Default Formats
        ◦ The INTERVAL YEAR TO MONTH Literal
        ◦ The INTERVAL DAY TO SECOND Literal
        ◦ Summary
    ● Conversion Functions
        ◦ Introduction
        ◦ Module Contents
        ◦ TO_CHAR() Conversion Function
        ◦ Format Models Introduction
        ◦ Format Models (YYYY/MM/DD)
        ◦ Format Models (MONTH/MON)
        ◦ Format Models (DAY/DY)
        ◦ Format Models (DDD/D)
        ◦ Format Models (WW/W)
        ◦ Format Models (Q/J)
        ◦ Format Models (DS)
        ◦ Format Models (DL)
        ◦ Format Models (HH/HH12/HH24/MI/SS/xFF)
        ◦ TO_DATE() Conversion Function
        ◦ TO_TIMESTAMP() Conversion Function
        ◦ TO_YMINTERVAL() Conversion Function
        ◦ TO_DSINTERVAL() Conversion Function
        ◦ NUMTOYMINTERVAL() Conversion Function
        ◦ NUMTODSINTERVAL() Conversion Function
        ◦ CAST() Conversion Function
        ◦ EXTRACT() Conversion Function
        ◦ Summary
    ● Additional Functions
        ◦ Introduction
        ◦ Module Contents
        ◦ The ADD_MONTHS() Function
        ◦ The MONTHS_BETWEEN() Function
        ◦ The NEXT_DAY() Function
        ◦ The LAST_DAY() Function
        ◦ The ROUND() Function
        ◦ The TRUNC() Function
        ◦ The SYSDATE and CURRENT_DATE Functions
        ◦ The SYSTIMESTAMP and CURRENT_TIMESTAMP Functions
        ◦ Summary

     


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top