DATEDIFF function in Oracle

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

Related Posts:

  1. ORA-01843 not a valid month- Comparing Dates
  2. ORA-00904: invalid identifier
  3. How do I UPDATE from a SELECT in SQL Server?
  4. how to fix oracle ORA-01722 invalid number error
  5. SQL SELECT WHERE field contains words
  6. SQL SELECT WHERE field contains words
  7. ORA-00979 not a group by expression
  8. ORA-00907: missing right parenthesis
  9. SQL SELECT WHERE field contains words
  10. How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
  11. ORA-00918: column ambiguously defined in SELECT *
  12. Oracle error : ORA-00905: Missing keyword
  13. How do I limit the number of rows returned by an Oracle query after ordering?
  14. Oracle SELECT TOP 10 records
  15. Can a foreign key be NULL and/or duplicate?
  16. How to Select Top 100 rows in Oracle?
  17. ORA-12560: TNS:protocol adaptor error
  18. Best way to do nested case statement logic in SQL Server
  19. ORA-00972 identifier is too long alias column name
  20. Oracle Apex column link from LOV values
  21. PLS-00103: Encountered the symbol when expecting one of the following:
  22. What’s the difference between RANK() and DENSE_RANK() functions in oracle?
  23. ORA-00918: column ambiguously defined in SELECT *
  24. ORA-00918: column ambiguously defined in SELECT *
  25. Oracle – ORA-01489: result of string concatenation is too long [duplicate]
  26. ORA-01861: literal does not match format string
  27. What is it exactly a BLOB in a DBMS context
  28. “ORA-01438: value larger than specified precision allowed for this column” when inserting 3
  29. How do you create a temporary table in an Oracle database?
  30. Oracle “Partition By” Keyword
  31. How to insert date values into table
  32. Oracle SQL: Update a table with data from another table
  33. SQL selecting rows by most recent date with two unique columns
  34. ORA-06502: PL/SQL: numeric or value error: character string buffer too small
  35. How to write a SQL DELETE statement with a SELECT statement in the WHERE clause?
  36. Comparing Dates in Oracle SQL
  37. Convert timestamp to date in Oracle SQL
  38. How do I reset a sequence in Oracle?
  39. SQL: Two select statements in one query
  40. Update statement with inner join on Oracle
  41. SQL conditional SELECT
  42. MySQL equivalent of DECODE function in Oracle
  43. Oracle: If Table Exists
  44. How to create id with AUTO_INCREMENT on Oracle?
  45. LEFT function in Oracle
  46. MySQL error: Unknown column in ‘where clause’
  47. What is the difference between Views and Materialized Views in Oracle?
  48. Postgresql column reference “id” is ambiguous
  49. How do I view the Explain Plan in Oracle Sql developer?
  50. How to order by column A and then by column B?
  51. ORA-01779: cannot modify a column which maps to a non key-preserved table
  52. ORA-01735: invalid ALTER TABLE option – Toad
  53. ora-06553 pls-306 wrong number or types of arguments in call to ‘ogc_x’
  54. Help me SELECT thumbnail from SQL and use
  55. how to SELECT meta values that are not null?
  56. What’s the best way to search for a UPC code in a Database?
  57. What is SELF JOIN and when would you use it? [duplicate]
  58. MySQL “CREATE TABLE IF NOT EXISTS” -> Error 1050
  59. Online SQL Query Syntax Checker
  60. Must declare the scalar variable
  61. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  62. IDENTITY_INSERT is set to OFF – How to turn it ON?
  63. How to reset AUTO_INCREMENT in MySQL
  64. What does SQL Select symbol || mean?
  65. Why does NULL = NULL evaluate to false in SQL server
  66. Difference between one-to-many and many-to-one relationship
  67. How do I format date and time on ssrs report?
  68. MySQL Error 1264: out of range value for column
  69. How to parse XML data in SQL server table
  70. What is the Oracle equivalent of SQL Server’s IsNull() function?
  71. Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 4 (Year)
  72. Postgres Error: More than one row returned by a subquery used as an expression
  73. SQL Queries “00904. 00000 – “%s: invalid identifier”
  74. How to divide two columns?
  75. SQL “select where not in subquery” returns no results
  76. ListAGG in SQLSERVER
  77. grant select on view
  78. The used SELECT statements have a different number of columns
  79. using sql count in a case statement
  80. Solutions for INSERT OR UPDATE on SQL Server
  81. “select * into table” Will it work for inserting data into existing table
  82. CASE IN statement with multiple values
  83. List of special characters for SQL LIKE clause
  84. Use wpdb->prepare for `order by` column name
  85. Cron While Editing Post
  86. find pods item where relationship to other pod is not set
  87. Export SQL query based on post type
  88. Convert a category of posts to a custom post type using (MySQL) queries
  89. Connect to Ms SQL Server
  90. wpdb prepare sql problem
  91. Can Anyone provide an example of RAW SQL for SELECTING posts by 2 or more tags
  92. REGEXP_REPLACE in post_contet
  93. Menu Order updating automatically
  94. How delete post_content records of specific category from phpmyadmin
  95. Fastest way to display 5000 post titles?
  96. How do I display SQL query on a specific page of my wordpress site
  97. Is it possible to utilize custom SQL for a single-post.php?
  98. How to handle my row actions on a custom list table in the admin section
  99. How can I avoid duplicate primary keys in SQL import?
  100. This SQL request call all time and overload my server : SELECT meta_value FROM wp_sitemeta WHERE meta_key = ‘wp_installer_network’ AND site_id = 1

Leave a Comment