Ispirer Website Ispirer Capabilities - Oracle Migration Free Trial

Oracle To_char(number) function to HiRDB

To_char(number) without format and nls_parameters

HiRDB has equivalent for To_char(number) without format and nls_parameters. SQLWays changes it to DIGITS function.

Oracle:

SELECT TO_CHAR(-10000) FROM t; 

HiRDB:

SELECT DIGITS(-10000) FROM t; 

To_char(number) with format

HiRDB has equivalent for To_char(number) with format. SQLWays changes it to NUMEDIT function.

Oracle:

SELECT TO_CHAR(-10000,'L99G999D99MI') FROM t;
SELECT TO_CHAR(10000,'S99G999D99') FROM t;

HiRDB:

SELECT NUMEDIT(-10000,'L99G999D99MI') FROM t;
SELECT NUMEDIT(10000,'+99G999D99') FROM t;

To_char(number) with nls_parameters

HiRDB hasn't equivalent for To_char(number) with nls_parameters. SQLWays leaves it as is and adds message /*Сould not convert ' TO_CHAR' */.

Oracle:

SELECT TO_CHAR(-10000,'L99G999D99MI', 'NLS_NUMERIC_CHARACTERS = '',.'')  FROM t;

HiRDB:

SELECT TO_CHAR(-10000,'L99G999D99MI', 'NLS_NUMERIC_CHARACTERS = '',.'')  FROM t;
/* Сould not convert 'TO_CHAR' */

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