Converts a number to a day-time interval.
Syntax
NUMTODSINTERVAL(n, unit)Example
Enter values below to update the example in real time.
due_date→-- 72시간을 인터벌로 변환
SELECT SYSDATE + NUMTODSINTERVAL(72, 'HOUR') AS due_date FROM DUAL;
Converts a number to a day-time interval.
NUMTODSINTERVAL(n, unit)Enter values below to update the example in real time.
due_date→-- 72시간을 인터벌로 변환
SELECT SYSDATE + NUMTODSINTERVAL(72, 'HOUR') AS due_date FROM DUAL;