select to_char(sysdate,'MM/DD/YYYY HH:MI:SS'),
to_char(sysdate + 1/24,'MM/DD/YYYY HH:MI:SS'),
systimestamp,
systimestamp + numtodsinterval(1,'hour')
from dual| TO_CHAR(SYSDATE,'MM/DD/YYYYHH:MI:SS') | TO_CHAR(SYSDATE+1/24,'MM/DD/YYYYHH:MI:SS') | SYSTIMESTAMP | SYSTIMESTAMP+NUMTODSINTERVAL(1,'HOUR') | 10/14/2015 06:02:07 | 10/14/2015 07:02:07 | 14-OCT-15 06.02.07.223246 AM -07:00 | 14-OCT-15 07.02.07.223246 AM -07:00 |
|---|
select sysdate + 1 as add_day,
systimestamp + numtodsinterval(1, 'day')
from dual| ADD_DAY | SYSTIMESTAMP+NUMTODSINTERVAL(1,'DAY') | 15-OCT-15 | 15-OCT-15 06.02.07.242242 AM -07:00 |
|---|
select sysdate + 7 as add_day,
systimestamp + numtodsinterval(7, 'day')
from dual| ADD_DAY | SYSTIMESTAMP+NUMTODSINTERVAL(7,'DAY') | 21-OCT-15 | 21-OCT-15 06.02.07.271689 AM -07:00 |
|---|
select add_months(sysdate, 1) add_month,
cast(add_months(systimestamp,1) as timestamp with time zone)
from dual| ADD_MONTH | CAST(ADD_MONTHS(SYSTIMESTAMP,1)ASTIMESTAMPWITHTIMEZONE) | 14-NOV-15 | 14-NOV-15 06.02.07.000000 AM US/PACIFIC |
|---|
select add_months(sysdate, 12) add_month,
cast(add_months(systimestamp,12) as timestamp with time zone)
from dual| ADD_MONTH | CAST(ADD_MONTHS(SYSTIMESTAMP,12)ASTIMESTAMPWITHTIMEZONE) | 14-OCT-16 | 14-OCT-16 06.02.07.000000 AM US/PACIFIC |
|---|