Equivalent function for DATEADD in Oracle

Question

I have to get a date that is 6 months from the system date in Oracle  And I have to get it by running an open-query from SQL  DATEADD MONTH -6  GETDATE     function serves the purpose in SQL  Does the function DATEADD MONTH -6  GETDATE    in SQL have an equivalent function in Oracle

User · Answer

Equivalent will be  ADD MONTHS  SYSDATE  -6

User · Answer

Not my answer    I wasn t too happy with the answers above and some additional searching yielded this    SELECT SYSDATE AS current date          SYSDATE   1 AS plus 1 day          SYSDATE   1 24 AS plus 1 hours          SYSDATE   1 24 60 AS plus 1 minutes          SYSDATE   1 24 60 60 AS plus 1 seconds  FROM   dual    which I found very helpful  From http   sqlbisam blogspot com 2014 01 add-date-interval-to-date-or-dateadd html

User · Answer

--ORACLE SQL EXAMPLE SELECT SYSDATE  TO DATE SUBSTR LAST DAY ADD MONTHS SYSDATE  -1   1 10   YYYY-MM-DD   FROM DUAL

User · Answer

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

[sql] Equivalent function for DATEADD() in Oracle

Examples related to sql

Examples related to oracle