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' */

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