How to use DATEs, TIMESTAMPs, and INTERVALs in Oracle Database
Oracle Database has three core data types for storing datetime values: DATE, TIMESTAMP, and INTERVAL. The database provides many functions to help you work with these types.
Watch this back-to-basics session to learn how to use datetime values in Oracle Database. Highlights include:
3:10 - Data types; DATE, TIMESTAMP, INTERVAL
6:30 - Why implicit conversion errors happen and how to stop them
9:45 - Default on conversion error clause
12:40 Validate_conversion function
15:00 Setting the default display format for datetime values
17:10 DATE and TIMESTAMP literals
18:15 TRUNC to round down dates
19:20 String-to-date conversion demos
25:30 Flexible format matching demo
32:25 Datetime to string conversion demo
34:10 Cast DATE - TIMESTAMP demo
35:30 Interval literals and conversion demo
37:05 Datetime arithmetic
38:50 Get a duration in seconds
40:30 Adding or removing months
40:55 Datetime arithmetic demo
42:45 Adding or removing months demo
53:00 Dealing with time zones
56:35 Demo of time zone logic
1:03:50 Final recap
Get the scripts https://bit.ly/SQL-ATOH-Datetimes
Learn SQL http://bit.ly/learn-sql-free-dfd-f
Watch video How to use DATEs, TIMESTAMPs, and INTERVALs in Oracle Database online without registration, duration hours minute second in high quality. This video was added by user Oracle Developers 20 January 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 7,959 once and liked it 119 people.