Table of Contents
Ispirer Website
Ispirer Capabilities - Oracle Migration
Free Trial
Oracle Extract function to HiRDB
Extract function with YEAR, MONTH, DAY, HOUR, MINUTE, SECOND
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;
Extract function with TIMEZONE_HOUR, TIMEZONE_MINUTE, TIMEZONE_REGION, TIMEZONE_ABBR
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 ' */