Get the number of days between two dates in Oracle, inclusive of the dates

by

In Oracle substracting two dates returns the number of days between two dates.
A minus operator works in the same way as for numbers:

20 - 20 = 0   ===>      2013-05-20  -  2013-05-20 = 0
25 - 20 = 5   ===>      2013-05-25  -  2013-05-20 = 5

If you want to include last number or last date, you need to add 1:

20 - 20 + 1 = 1   ===>      2013-05-20  -  2013-05-20  + 1 = 1
25 - 20 + 1 = 6   ===>      2013-05-25  -  2013-05-20  + 1 = 6

More Related Contents:

  1. Maximum Number of times we can query an oracle database [closed]
  2. How to uninstall / completely remove Oracle 11g (client)?
  3. Calculate difference between 2 date / times in Oracle SQL
  4. Oracle trigger after insert or delete
  5. ORA-12514 TNS:listener does not currently know of service requested in connect descriptor
  6. How to handle Day Light Saving in Oracle database
  7. What is the effect of placing the commit after DML in procedure?
  8. Auto Increment for Oracle
  9. ORA-01017 Invalid Username/Password when connecting to 11g database from 9i client
  10. PL/SQL ORA-01422: exact fetch returns more than requested number of rows
  11. Oracle Search all tables all columns for string [duplicate]
  12. NLS_NUMERIC_CHARACTERS setting for decimal
  13. creating parameterized views in oracle11g
  14. Create Pivot view in SQL from a SQL table
  15. How to create a user in Oracle 11g and grant permissions
  16. Table-Valued Functions in ORACLE 11g ? ( parameterized views )
  17. Trigger to enforce M-M relationship
  18. Oracle: how to add minutes to a timestamp?
  19. How can I describe a table in Oracle without using the DESCRIBE command?
  20. Functions vs procedures in Oracle
  21. How to insert a column in a specific position in oracle without dropping and recreating the table?
  22. HikariCP: What database level timeouts should be considered to set maxLifetime for Oracle 11g
  23. passing in table name as plsql parameter
  24. How to use parameters in a ‘where value in…’ clause?
  25. Why cannot I create triggers on objects owned by SYS?
  26. No more data to read from socket
  27. return resultset from function
  28. ORA-12704: character set mismatch
  29. What is the dual table in Oracle?
  30. Why are Oracle table/column/index names limited to 30 characters?

Leave a Comment