Oracle Difference Date. This will give you the difference in days. The difference may be returned in whole years months weeks or days or a combination of these according to specified options.
The difference may be returned in whole years months weeks or days or a combination of these according to specified options. Getting the difference between dates. You can use different date format to calculate difference of dates.
Select datediff day 200604 200805 as date difference from dual.
This will give you the difference in days. If your date is stored as character data you have to convert it to a date type first. In oracle the difference in days and or fractions thereof between two dates can be found using subtraction. Valid values can be.
