Equivalent function for DATEADD() in Oracle

by

Method1: ADD_MONTHS

ADD_MONTHS(SYSDATE, -6)

Method 2: Interval

SYSDATE - interval '6' month

Note:
if you want to do the operations from start of the current month always, TRUNC(SYSDATE,'MONTH') would give that. And it expects a Date datatype as input.

More Related Contents:

  1. SQL Query output in VBA is different than in SQL Oracle
  2. I want to find out how much zero come after 1 in SQL
  3. Update statement with inner join on Oracle
  4. Splitting string into multiple rows in Oracle
  5. Is there any function in oracle similar to group_concat in mysql? [duplicate]
  6. How to use the ‘as’ keyword to alias a table in Oracle?
  7. Can a foreign key be NULL and/or duplicate?
  8. What is the string concatenation operator in Oracle?
  9. Using an Alias in a WHERE clause
  10. How can I introduce multiple conditions in LIKE operator?
  11. Is there any boolean type in Oracle databases?
  12. SQL (ORACLE): ORDER BY and LIMIT [duplicate]
  13. Dynamic Oracle Pivot_In_Clause
  14. How can I select from list of values in Oracle
  15. Convert Unixtime to Datetime SQL (Oracle)
  16. How can I get the number of days between 2 dates in Oracle 11g? [duplicate]
  17. ORA 00904 Error:Invalid Identifier
  18. Deferrable Constraints in SQL Server
  19. Nth max salary in Oracle
  20. How to select records with maximum values in two columns?
  21. What does the colon sign “:” do in a SQL query?
  22. How do I get textual contents from BLOB in Oracle SQL
  23. Inserting into Oracle and retrieving the generated sequence ID
  24. adding primary key to sql view
  25. How do I call an Oracle stored procedure from an Excel VBA script?
  26. Search an Oracle database for tables with specific column names?
  27. ORA-01861: literal does not match format string
  28. Query a Table’s Foreign Key relationships
  29. Backup SQL Schema Only?
  30. IN vs OR of Oracle, which faster?

Leave a Comment