Ispirer Website
Ispirer Capabilities - Oracle Migration
Free Trial
HiRDB database has equivalents Extract function with YEAR, MONTH, DAY, HOUR, MINUTE, SECOND. SQLWays changes it.
Oracle:
select extract (YEAR from c1), extract (MONTH from c1), extract (DAY from c1), extract (HOUR from c1) , extract (MINUTE from c1), extract (SECOND from c1) from t;
HiRDB:
select YEAR(c1) , MONTH(c1), DAY(c1), HOUR(c1) , MINUTE(c1) , SECOND(c1) from t;
HiRDB hasn't equivalents for Extract function with TIMEZONE_HOUR, TIMEZONE_MINUTE, TIMEZONE_REGION, TIMEZONE_ABBR. SQLWays leaves it as is and adds message /* SQLWays: Could not convert 'extract' */.
Oracle:
select extract (TIMEZONE_HOUR from c1) from t;
HiRDB:
select extract(TIMEZONE_HOUR from c1) from t; /* Сould not convert 'extract ' */