Oracle date difference to get number of years

by

I’d use months_between, possibly combined with floor:

select floor(months_between(date '2012-10-10', date '2011-10-10') /12) from dual;

select floor(months_between(date '2012-10-9' , date '2011-10-10') /12) from dual;

floor makes sure you get down-rounded years. If you want the fractional parts, you obviously want to not use floor.

More Related Contents:

  1. How to get records randomly from the oracle database?
  2. How to use a table type in a SELECT FROM statement?
  3. ORA-01830: date format picture ends before converting entire input string / Select sum where date query
  4. How to uninstall / completely remove Oracle 11g (client)?
  5. Get counts of all tables in a schema
  6. Determining location of relevant tnsnames.ora file
  7. Default row ordering for select query in oracle
  8. oracle convert unix epoch time to date
  9. Oracle trigger after insert or delete
  10. ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
  11. Difference between a user and a schema in Oracle?
  12. Base64 encoding and decoding in oracle
  13. What is the dual table in Oracle?
  14. How to avoid variable substitution in Oracle SQL Developer
  15. Recursion In Oracle
  16. How to kill a running SELECT statement
  17. creating parameterized views in oracle11g
  18. Oracle’s default date format is YYYY-MM-DD, WHY?
  19. PL/SQL print out ref cursor returned by a stored procedure
  20. Default Schema in Oracle Connection URL
  21. Trigger to enforce M-M relationship
  22. How do you get nicely formatted results from an Oracle procedure that returns a reference cursor?
  23. Oracle: how to INSERT if a row doesn’t exist
  24. Valid Date Checks in Oracle
  25. Functions vs procedures in Oracle
  26. Oracle: difference between max(id)+1 and sequence.nextval
  27. Why cannot I create triggers on objects owned by SYS?
  28. automating rollback script oracle
  29. How do I get column datatype in Oracle with PL-SQL with low privileges?
  30. How to View Oracle Stored Procedure using SQLPlus?

Leave a Comment