오라클 날짜 더하기

1일(day) 더하기

select sysdate, sysdate + 1 from dual;

1시(hour) 더하기

select sysdate, sysdate + 1/(24) from dual;

1분(minute) 더하기

select sysdate, sysdate + 1/(24*60) from duall;

1초(second) 더하기

select sysdate, sysdate + 1/(24*60*60) from dual;

1년(year) 더하기

select sysdate, sysdate + (1*365) from dual;