2013
Pluralsight
Scott Hecht
2h 24m
English

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.

01. Getting Started
01. Introduction and Course Contents.wmv
02. Database Version.wmv
03. Data used in Course.wmv
04. The DUAL Table.wmv
05. Missing Content.wmv
06. Summary.wmv

02. Overview
01. Introduction.wmv
02. Module Contents.wmv
03. Data Types.wmv
04. Congruence.wmv
05. Literals.wmv
06. Conversion Functions.wmv
07. Additional Functions.wmv
08. Summary.wmv

03. Date Data Type
01. Introduction.wmv
02. Module Contents.wmv
03. The DATE Data Type.wmv
04. Storage.wmv
05. Initialization.wmv
06. Operations.wmv
07. Summary.wmv

04. TIMESTAMP Data Type
01. Introduction.wmv
02. Module Contents.wmv
03. The TIMESTAMP Data Type.wmv
04. Storage.wmv
05. Initialization.wmv
06. Operations.wmv
07. Summary.wmv

05. INTERVAL Data Types
01. Introduction.wmv
02. Module Contents.wmv
03. The INTERVAL Data Types.wmv
04. Storage.wmv
05. Initialization.wmv
06. Operations.wmv
07. Summary.wmv

06. Literals
01. Introduction.wmv
02. Module Contents.wmv
03. A Literal Overview.wmv
04. The DATE Literal.wmv
05. The TIMESTAMP Literal.wmv
06. A Warning About Default Formats.wmv
07. The INTERVAL YEAR TO MONTH Literal.wmv
08. The INTERVAL DAY TO SECOND Literal.wmv
09. Summary.wmv

07. Conversion Functions
01. Introduction.wmv
02. Module Contents.wmv
03. TO_CHAR() Conversion Function.wmv
04. Format Models Introduction.wmv
05. Format Models (YYYY MM DD).wmv
06. Format Models (MONTH MON).wmv
07. Format Models (DAY DY).wmv
08. Format Models (DDD D).wmv
09. Format Models (WW W).wmv
10. Format Models (Q J).wmv
11. Format Models (DS).wmv
12. Format Models (DL).wmv
13. Format Models (HH HH12 HH24 MI SS xFF).wmv
14. TO_DATE() Conversion Function.wmv
15. TO_TIMESTAMP() Conversion Function.wmv
16. TO_YMINTERVAL() Conversion Function.wmv
17. TO_DSINTERVAL() Conversion Function.wmv
18. NUMTOYMINTERVAL() Conversion Function.wmv
19. NUMTODSINTERVAL() Conversion Function.wmv
20. CAST() Conversion Function.wmv
21. EXTRACT() Conversion Function.wmv
22. Summary.wmv

08. Additional Functions
01. Introduction.wmv
02. Module Contents.wmv
03. The ADD_MONTHS() Function.wmv
04. The MONTHS_BETWEEN() Function.wmv
05. The NEXT_DAY() Function.wmv
06. The LAST_DAY() Function.wmv
07. The ROUND() Function.wmv
08. The TRUNC() Function.wmv
09. The SYSDATE and CURRENT_DATE Functions.wmv
10. The SYSTIMESTAMP and CURRENT_TIMESTAMP Functions.wmv
11. Summary.wmv

http://pluralsight.com/

Download File Size:174.27 MB

---