Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

Time Interval Related Functions

Function Description NUMTODSINTERVAL(x, interval_unit)Converts the number x to an INTERVAL DAY TO SECOND with the interval for x supplied in interval_unit, which you may set to DAY, HOUR, MINUTE, or SECOND. NUMTOYMINTERVAL(x, interval_unit)Converts the number x to an INTERVAL YEAR TO MONTH with the interval for x supplied in interval_unit, which you may set to YEAR or MONTH. TO_DSINTERVAL(x)Converts the string x to an INTERVAL DAY TO SECOND. TO_YMINTERVAL(x)Converts the string x to an INTERVAL YEAR TO MONTH.