Oracle Timediff. This answer applies to dates represented by the oracle data type date. The oracle date type can be used to do subtraction but the returning number will be given in days as you see on the next example the returning number is integer.
Oracle also has a data type timestamp which can also represent a date with time. This answer applies to dates represented by the oracle data type date. Two dates or what is the amount of elapsed time.
Datediff date part it will be year quarter month day hour etc date 1 date 2.
Datediff use the datedifffunction to calculate the difference between two dates or datetimes in days or seconds. Oracle supports date arithmetic and you can make expressions like date1 date2 using date subtraction to get the difference between the two dates. The oracle date type can be used to do subtraction but the returning number will be given in days as you see on the next example the returning number is integer. Oracle datediff function examples and syntax.
