Table of Contents
Ispirer Website
Ispirer Capabilities - Oracle Migration
Free Trial
Oracle Round(date) function to HiRDB
Round(date) function with one parameter
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' */
Round(date) function with second parameter as date format
Round(date) function with second parameter as month date format
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;
Round(date) function with second parameter as not month date format
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' */
Round(date) function with unknown parameter’s data type
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' */