Add days Oracle SQL

Question

SELECT ORDER NUM  CUSTOMER NUM  CUSTOMER NAME  ADD DAYS  ORDER DATE  20  FROM CUSTOMER  ORDERS     Oracle Express says ADD DAYS invalid  Any ideas what Am I doing wrong

User · Answer

You can use the plus operator to add days to a date   order date   20

User · Answer

Some disadvantage of  INTERVAL  1  DAY  is that bind variables cannot be used for the number of days added  Instead  numtodsinterval can be used  like in this small example   select trunc sysdate    numtodsinterval  x   day   tag from dual   See also  NUMTODSINTERVAL in Oracle Database Online Documentation

User · Answer

If you want to add N days to your days  You can use the plus operator as follows -    SELECT   SYSDATE   N   FROM DUAL

User · Answer

It s Simple You can use  select  sysdate 2  as new date from dual    This will add two days from current date

User · Answer

In a more general way you can use  INTERVAL   Here some examples   1  add a day  select sysdate   INTERVAL  1  DAY from dual    2  add 20 days  select sysdate   INTERVAL  20  DAY from dual    2  add some minutes  select sysdate   INTERVAL  15  MINUTE from dual

[sql] Add days Oracle SQL

Examples related to sql

Examples related to oracle11g