Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

NUMTOYMINTERVAL(1 5, YEAR)

SQL>  SELECT   2    NUMTOYMINTERVAL(1.5, 'YEAR')   3  FROM dual; NUMTOYMINTERVAL(1.5,'YEAR') --------------------------------------------------------------------------- +000000001-06 SQL>