Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

NUMTOYMINTERVAL(3 25, MONTH)

SQL>  SELECT   2    NUMTOYMINTERVAL(3.25, 'MONTH')   3  FROM dual; NUMTOYMINTERVAL(3.25,'MONTH') --------------------------------------------------------------------------- +000000000-03 SQL>