Code: |
SELECT RATE,CONCAT(CHAR(DEC(RATE*100,3,2 )),'%') AS PERCENT FROM Table1 RATE PERCENT ---------- ------- 0.0400000 4.00% 0.0425000 4.25% 0.0450000 4.50% 0.0475000 4.75% 0.0500000 5.00% 0.0525000 5.25% 0.0550000 5.50% 0.0575000 5.75% 0.0600000 6.00% 0.0625000 6.25% 0.0675000 6.75% 0.0725000 7.25% 0.0775000 7.75% 0.0825000 8.25% |
kolusu wrote: |
what is the percentage if the rate column had a value of 9.1234567? |
Code: |
SELECT RATE ,TO_CHAR(RATE * 100,'99.99') || '%' AS PERCENT FROM TABLE ; |
Code: |
QUERY MESSAGES: Argument '1' of scalar function 'TO_CHAR' is invalid. |
Code: |
SELECT RATE ,TO_CHAR(RATE,'99.99') FROM Table ---------+---------+---------+---------+---------+---------+---------+---------+ DSNT408I SQLCODE = -171, ERROR: THE DATA TYPE, LENGTH, OR VALUE OF ARGUMENT 1 OF TO_CHAR IS INVALID DSNT418I SQLSTATE = 42815 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNXOBFA SQL PROCEDURE DETECTING ERROR DSNT416I SQLERRD = 30 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION DSNT416I SQLERRD = X'0000001E' X'00000000' X'00000000' X'FFFFFFFF' X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION |
Code: |
Use EXEC to continue; SQL to view/edit SQL; SAVE ; SIZE Table Name: Env.Table Max Rows to Select ===> 2000 (* = ALL ROWS) SEL COLUMN NAME TYPE(LEN) ORDER (A/D) WHERE More: > --- ------------------ ------------------ -- - ----+----1----+----2----+ ___ RATE DECIMAL(7,7) |
Code: |
SELECT TO_CHAR(0.0400000 * 100,'99.99') || '%' AS PERCENT FROM SYSIBM.SYSDUMMY1 ; ---------+---------+---------+---------+---------+--------- PERCENT ---------+---------+---------+---------+---------+--------- 4.00% |
output generated using printer-friendly topic mod. All times are GMT - 5 Hours