Examples for validating dates in pl sql
It is typically good for representing data for when something has happened or should happen in the future. Oracle provides functions for many common date operations.
A new little feature in Oracle Database 12.2 is, that you can convert strings to dates without worrying about exception handling.What needs to be realized when doing the calculation is that when you do subtraction between dates, you get a number that represents the number of days. Oracle has expanded on the DATE datatype and has given us the TIMESTAMP datatype which stores all the information that the DATE datatype stores, but also includes fractional seconds.