Ispirer Website Ispirer Capabilities - Oracle Migration Free Trial

Oracle NUMTOYMINTERVAL function to HiRDB

HiRDB hasn't equivalents for NUMTOYMINTERVAL function. SQLWays leaves it as is and adds message /* SQLWays: Could not convert 'NUMTOYMINTERVAL' */.

Oracle:

select numtoyminterval(99,'year') from t; 

HiRDB:

select numtoyminterval(99,'year') from t;
/* SQLWays: Could not convert 'numtoyminterval' */

© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.