https://wiki.ispirer.com/ 2026-04-14T21:10: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/db2/functions/numeric-functions/abs?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - ABS Function IBM DB2 - ABS Syntax ABS() Description ABS function returns absolute value Equivalents in Other Databases Database Equivalent Oracle ABS SQL Server ABS text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/numeric-functions/acos?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - ACOS Function IBM DB2 - ACOS Syntax ACOS() Description ACOS function returns arc cosine Equivalents in Other Databases Database Equivalent Oracle ACOS SQL Server ACOS text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/numeric-functions/asin?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - ASIN Function IBM DB2 - ASIN Syntax ASIN() Description ASIN function returns arc sine Equivalents in Other Databases Database Equivalent Oracle ASIN SQL Server ASIN text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/numeric-functions/atan?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - ATAN Function IBM DB2 - ATAN Syntax ATAN() Description ATAN function returns arc tangent Equivalents in Other Databases Database Equivalent Oracle ATAN SQL Server ATAN text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/numeric-functions/atan2?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - ATAN2 Function IBM DB2 - ATAN2 Syntax ATAN2() Description ATAN2 function returns arc tangent for the quotient of two expressions Equivalents in Other Databases Database Equivalent Oracle ATAN2 SQL Server ATN2 text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/numeric-functions/atanh?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - ATANH Function IBM DB2 - ATANH Syntax ATANH() Description ATANH function returns hyperbolic arc tangent text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/numeric-functions/ceiling?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - CEILING Function IBM DB2 - CEILING Syntax CEILING() Description CEILING function returns smallest integer greater than or equal to specified Equivalents in Other Databases Database Equivalent Oracle CEIL SQL Server CEILING text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/numeric-functions/cos?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - COS Function IBM DB2 - COS Syntax COS() Description COS function returns cosine Equivalents in Other Databases Database Equivalent Oracle COS SQL Server COS text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/numeric-functions/cosh?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - COSH Function IBM DB2 - COSH Syntax COSH() Description COSH function returns hyperbolic cosine Equivalents in Other Databases Database Equivalent Oracle COSH text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/numeric-functions/cot?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - COT Function IBM DB2 - COT Syntax COT() Description COT function returns cotangent Equivalents in Other Databases Database Equivalent SQL Server COT text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/numeric-functions/degrees?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - DEGREES Function IBM DB2 - DEGREES Syntax DEGREES() Description DEGREES function returns degrees for the value in radians Equivalents in Other Databases Database Equivalent SQL Server DEGREES text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/numeric-functions/exp?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - EXP Function IBM DB2 - EXP Syntax EXP() Description EXP function returns e rised to the specified power Equivalents in Other Databases Database Equivalent Oracle EXP SQL Server EXP text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/numeric-functions/floor?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - FLOOR Function IBM DB2 - FLOOR Syntax FLOOR() Description FLOOR function returns largest integer equal to or less than specified Equivalents in Other Databases Database Equivalent Oracle FLOOR SQL Server FLOOR text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/numeric-functions/ln?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - LN Function IBM DB2 - LN Syntax LN() Description LN function returns natural logarithm Equivalents in Other Databases Database Equivalent Oracle LN SQL Server LOG text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/numeric-functions/log?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - LOG Function IBM DB2 - LOG Syntax LOG() Description LOG function returns natural logarithm Equivalents in Other Databases Database Equivalent Oracle LN SQL Server LOG text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/numeric-functions/log10?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - LOG10 Function IBM DB2 - LOG10 Syntax LOG10() Description LOG10 function returns logarithm Equivalents in Other Databases Database Equivalent Oracle LOG SQL Server LOG10 text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/numeric-functions/mod?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - MOD Function IBM DB2 - MOD Syntax MOD() Description MOD function returns remainder of the division Equivalents in Other Databases Database Equivalent Oracle MOD text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/numeric-functions/multiply-alt?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - MULTIPLY_ALT Function IBM DB2 - MULTIPLY_ALT Syntax MULTIPLY_ALT() Description MULTIPLY_ALT function returns result of multiplication of two arguments as the decimal value text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/numeric-functions/power?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - POWER Function IBM DB2 - POWER Syntax POWER() Description POWER function returns value raised to the power specified Equivalents in Other Databases Database Equivalent Oracle POWER SQL Server POWER text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/numeric-functions/radians?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - RADIANS Function IBM DB2 - RADIANS Syntax RADIANS() Description RADIANS function returns radians for the value in degrees Equivalents in Other Databases Database Equivalent SQL Server RADIANS text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/numeric-functions/rand?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - RAND Function IBM DB2 - RAND Syntax RAND() Description RAND function returns random floating value Equivalents in Other Databases Database Equivalent SQL Server RAND text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/numeric-functions/round?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - ROUND Function IBM DB2 - ROUND Syntax ROUND() Description ROUND function returns rounded value Equivalents in Other Databases Database Equivalent Oracle ROUND (number) SQL Server ROUND text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/numeric-functions/sign?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - SIGN Function IBM DB2 - SIGN Syntax SIGN() Description SIGN function returns sign Equivalents in Other Databases Database Equivalent Oracle SIGN SQL Server SIGN text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/numeric-functions/sin?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - SIN Function IBM DB2 - SIN Syntax SIN() Description SIN function returns sine Equivalents in Other Databases Database Equivalent Oracle SIN SQL Server SIN text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/numeric-functions/sinh?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - SINH Function IBM DB2 - SINH Syntax SINH() Description SINH function returns hyperbolic sine Equivalents in Other Databases Database Equivalent Oracle SINH text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/numeric-functions/sqrt?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - SQRT Function IBM DB2 - SQRT Syntax SQRT() Description SQRT function returns square root Equivalents in Other Databases Database Equivalent Oracle SQRT SQL Server SQRT text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/numeric-functions/tan?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - TAN Function IBM DB2 - TAN Syntax TAN() Description TAN function returns tangent Equivalents in Other Databases Database Equivalent Oracle TAN SQL Server TAN text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/numeric-functions/tanh?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - TANH Function IBM DB2 - TANH Syntax TANH() Description TANH function returns hyperbolic tangent Equivalents in Other Databases Database Equivalent Oracle TANH text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions/numeric-functions/truncate?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - TRUNCATE Function IBM DB2 - TRUNCATE Syntax TRUNCATE() Description TRUNCATE function returns truncated value Equivalents in Other Databases Database Equivalent Oracle TRUNC (number)