CODEWITHSUNDEEP
netezza
thephlyone
thephlyone

Reputation: 11

How to convert a double to two decimal places in netezza

I have tried everything I could on Netezza! Here is what I've tried:

  1. SELECT 45/CAST(7 AS DOUBLE) ---> 6.4285714285714

  2. But I want results to be 6.43 so I tried SELECT ROUND(45/CAST(7 AS DOUBLE), 2) but get an error: 'NZOLEDB' failed with no error message available, result code: DB_E_ERRORSOCCURRED(0x80040E21).

  3. Also tried SELECT 45/CAST(7 AS DOUBLE) :: DECIMAL(5,2). Get same as error as in point 2 above.

Could someone please assist! It's very frustrating.

Upvotes: 1

Views: 5941

Answers (1)

Varun Bajaj
Varun Bajaj

Reputation: 1043

SYSTEM.ADMIN(ADMIN)=> select to_number((45*1.0)/7,99.99);
TO_NUMBER
-----------
 6.42
(1 row)


SYSTEM.ADMIN(ADMIN)=> select version();
              VERSION
-----------------------------------
 Release 7.0.4 (P-1) [Build 33519]
(1 row)

Hope this will give you desired result.

Upvotes: 1

Related Questions