DATEDIFF function in Oracle [duplicate]

by

In Oracle, you can simply subtract two dates and get the difference in days. Also note that unlike SQL Server or MySQL, in Oracle you cannot perform a select statement without a from clause. One way around this is to use the builtin dummy table, dual:

SELECT TO_DATE('2000-01-02', 'YYYY-MM-DD') -  
       TO_DATE('2000-01-01', 'YYYY-MM-DD') AS DateDiff
FROM   dual

More Related Contents:

  1. How can I select from list of values in Oracle
  2. How to kill a running SELECT statement
  3. How do I select all the columns from a table, plus additional columns like ROWNUM?
  4. Check if two “select”s are equivalent
  5. Search All Fields In All Tables For A Specific Value (Oracle)
  6. Oracle: how to UPSERT (update or insert into a table?)
  7. Get top results for each group (in Oracle)
  8. Oracle SQL query: Retrieve latest values per group based on time [duplicate]
  9. ORA-12560: TNS:protocol adaptor error
  10. Oracle “(+)” Operator
  11. How do you create a temporary table in an Oracle database?
  12. What exactly do quotation marks around the table name do?
  13. JOIN two SELECT statement results
  14. How can I get column names from a table in Oracle?
  15. How to store only time; not date and time?
  16. How does GROUP BY work?
  17. What’s the difference between RANK() and DENSE_RANK() functions in oracle?
  18. How to delete from select in MySQL?
  19. How to get the last row of an Oracle table
  20. Select without a FROM clause in Oracle
  21. INSERT SELECT statement in Oracle 11G
  22. Oracle insert if row does not exist
  23. Display names of all constraints for a table in Oracle SQL
  24. SQL Oracle LEFT JOIN and SUBQUERY error: ORA-00905: missing keyword
  25. Does ‘Select’ always order by primary key?
  26. How to use a dynamic parameter in a IN clause of a JPA named query?
  27. How to check if a column exists before adding it to an existing table in PL/SQL?
  28. What’s the correct name for an “association table” (a many-to-many relationship) [closed]
  29. Why doesn’t Oracle SQL allow us to use column aliases in GROUP BY clauses?
  30. Oracle ‘Partition By’ and ‘Row_Number’ keyword

Leave a Comment