Ispirer Website
Ispirer Capabilities - Oracle Migration
Free Trial
HiRDB hasn't equivalent for Round(date) function with one parameter. SQLWays leaves it as is and adds message /* Сould not convert 'ROUND' */.
Oracle:
SELECT ROUND(col1) FROM t;
HiRDB:
SELECT ROUND(col1) FROM t; /* Сould not convert 'ROUND' */
HiRDB has equivalent for Round(date) function with second parameter as month date format. SQLWays changes it to roundmonth function.
Oracle:
SELECT ROUND(col1,'month'), ROUND(col1,'mon'), ROUND(col1,'mm'), ROUND(col1,'rm') FROM t;
HiRDB:
SELECT roundmonth(col1), roundmonth(col1), roundmonth(col1), roundmonth(col1) FROM t;
HiRDB hasn't equivalent for Round(date) function with second parameter as not month date format. SQLWays leaves it as is and adds message /* Сould not convert 'ROUND' */.
Oracle:
SELECT ROUND(col2,'day') FROM t;
HiRDB:
select ROUND(col2,'day') from t; /* Сould not convert 'ROUND' */
HiRDB hasn't equivalent for Round(date) function with unknown parameter’s data type. SQLWays leaves it as is and adds message /* Сould not convert 'ROUND' */.
Oracle:
create table test_func_types1 ( c1 float, c2 float ); SELECT ROUND(c3) FROM test_func_types1; SELECT ROUND(c4,1) FROM test_func_types1; SELECT ROUND(c5, 'month') FROM test_func_types1; SELECT ROUND(c6, 'day') FROM test_func_types1;
HiRDB:
create table test_func_types1 ( c1 float, c2 float ); SELECT ROUND(c3) FROM test_func_types1; /* SQLWays: This conversion has inappropriate possibility */ SELECT ROUND(c4,1) FROM test_func_types1; /* SQLWays: This conversion has inappropriate possibility */ SELECT roundmonth(c5) FROM test_func_types1; SELECT ROUND(c6, 'day') FROM test_func_types1; /* Сould not convert 'ROUND' */