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

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