This example returns the date of the next Tuesday after March 15, 1998.

SELECT NEXT_DAY('15-MAR-98','TUESDAY') "NEXT DAY"
FROM DUAL;

NEXT DAY
---------

16-MAR-98
>>>>>>>>>>>>>>>>>>>
Why do you need TRUNCATE?