https://wiki.ispirer.com/ 2026-04-14T07:42:55+00:00 https://wiki.ispirer.com/ https://wiki.ispirer.com/lib/tpl/dokuwiki/images/favicon.ico text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/date-and-time-functions/add-months?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle ADD_MONTHS function to HiRDB SQLWays changes ADD_MONTHS function to expression with plus and adds specificator month to integer value. Oracle: select add_months(date_col1, 2) from t; HiRDB: select date_col1+2 MONTH from t; References in Wiki text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/date-and-time-functions/current-date?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle CURRENT_DATE function to HiRDB HiRDB database supports CURRENT_DATE function. SQLWays leaves it as is. Oracle: n := CURRENT_DATE; HiRDB: SET n = CURRENT_DATE; References in Wiki Database Reference Oracle CURRENT_DATE HiRDB CURRENT_DATE text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/date-and-time-functions/current-timestamp?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle CURRENT_TIMESTAMP function to HiRDB HiRDB database supports CURRENT_TIMESTAMP function. SQLWays leaves CURRENT_TIMESTAMP without precision as is. CURRENT_TIMESTAMP(precision) converted according rules: -if precision >= 6 , converted to CURRENT_TIMESTAMP(6) text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/date-and-time-functions/dbtimezone?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle DBTIMEZONE function to HiRDB HiRDB hasn't equivalents for DBTIMEZONE function. SQLWays leaves it as is and adds message /* SQLWays: Could not convert 'DBTIMEZONE' */. Oracle: n := DBTIMEZONE; HiRDB: SET n = DBTIMEZONE; /* SQLWays: Could not convert 'DBTIMEZONE' */ text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/date-and-time-functions/extract-datetime?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing 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; text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/date-and-time-functions/from-tz?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle FROM_TZ function to HiRDB HiRDB hasn't equivalents for FROM_TZ function. SQLWays leaves it as is and adds message /* SQLWays: Could not convert 'FROM_TZ' */. Oracle: select from_tz(col1, col2) from t; HiRDB: select from_tz(col1, col2) from t; /* SQLWays: Could not convert 'from_tz' */ text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/date-and-time-functions/last-day?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle LAST_DAY function to HiRDB HiRDB database supports LAST_DAY function. SQLWays leaves it as is. Oracle: n := LAST_DAY(col1); HiRDB: SET n = LAST_DAY(col1); text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/date-and-time-functions/localtimestamp?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle Localtimestamp function to HiRDB HiRDB hasn't equivalent for Localtimestamp function. SQLWays leaves it as is and adds message /* This conversion has inappropriate possibility*/. Oracle: select localtimestamp from t; HiRDB: select current_timestamp from t; /*This conversion has inappropriate possibility*/ text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/date-and-time-functions/months-between?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle MONTHS_BETWEEN function to HiRDB HiRDB database supports MONTHS_BETWEEN function. SQLWays leaves it as is. Oracle: select MONTHS_BETWEEN(col1,col2) from t; HiRDB: select MONTHS_BETWEEN(col1,col2) from t; text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/date-and-time-functions/next-day?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle Next_day function to HiRDB HiRDB database supports Next_day function. SQLWays leaves it as is. Oracle: select next_day(CURRENT_DATE, 'Sunday'), next_day(CURRENT_DATE, 'monday'), next_day(CURRENT_DATE, 'Tuesday'), next_day(CURRENT_DATE, 'Wednesday'), next_day(CURRENT_DATE, 'Thursday'), next_day(CURRENT_DATE, 'Friday'), next_day(CURRENT_DATE, 'Saturday') from t; text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/date-and-time-functions/round-date?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing 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; text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/date-and-time-functions/sessiontimezone?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle SESSIONTIMEZONE function to HiRDB HiRDB hasn't equivalents for SESSIONTIMEZONE function. SQLWays leaves it as is and adds message /* SQLWays: Could not convert 'SESSIONTIMEZONE' */. Oracle: select sessiontimezone from t; HiRDB: select sessiontimezone from t; /* SQLWays: Could not convert 'sessiontimezone' */ text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/date-and-time-functions/sys-extract-utc?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle SYS_EXTRACT_UTC function to HiRDB HiRDB hasn't equivalents for SYS_EXTRACT_UTC function. SQLWays leaves it as is and adds message /* SQLWays: Could not convert 'SYS_EXTRACT_UTC' */. Oracle: select sys_extract_utc(a) from t; HiRDB: select sys_extract_utc(a) from t; /* SQLWays: Could not convert 'sys_extract_utc' */ text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/date-and-time-functions/sysdate?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle Systimestamp function to HiRDB HiRDB has equivalent for Systimestamp function. SQLWays changes it to CURRENT_TIMESTAMP and adds message /*This conversion has inappropriate possibility*/. Oracle: SELECT systimestamp FROM t; HiRDB: SELECT CURRENT_TIMESTAMP FROM t; /*This conversion has inappropriate possibility*/ text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/date-and-time-functions/trunc-date?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle Trunc(date) function to HiRDB Trunc(date) with YEAR, SYYYY, YYYY, SYEAR, YYY, YY, Y formats HiRDB has equivalent for Trunc(date) with YEAR, SYYYY, YYYY, SYEAR, YYY, YY, Y formats. SQLWays changes it to truncyear function. Oracle: SELECT TRUNC(c1, 'YEAR'), TRUNC(c1, 'SYYYY'), TRUNC(c1, 'YYYY'), TRUNC(c1, 'SYEAR'), TRUNC(c1, 'YYY'), TRUNC(c1, 'YY'), TRUNC(c1, 'Y') FROM t; text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/date-and-time-functions/tz-offset?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle Tz_offset function to HiRDB HiRDB hasn't equivalent for Tz_offset function. SQLWays leaves it as is and adds message /*Сould not convert ' TZ_OFFSET '*/. Oracle: SELECT TZ_OFFSET('US/Eastern') FROM t; HiRDB: SELECT TZ_OFFSET('US/Eastern') from t; /* Сould not convert ' TZ_OFFSET ' */