Forum Stats

  • 3,728,440 Users
  • 2,245,618 Discussions
  • 7,853,528 Comments

Discussions

Amount in decimal

Ricky007
Ricky007 Member Posts: 566 Blue Ribbon
edited November 2020 in SQL & PL/SQL

Dear Expert

Sorry if i had posted in wrong window.

Please help me to convert amount to two decimal .

CREATE TABLE AMT_CONV

(

AMT NUMBER

);


INSERT INTO AMT_CONV VALUES(1000);

INSERT INTO AMT_CONV VALUES(0);

Tried Query

select AMT,to_char(AMT/100 ,'9999999999999999.99') AS RESULT from AMT_CONV;



Expected result

AMT RESULT

1000 10.00

0 0.00 ----- BUT FOR THE ABOVE QUERY I AM GETTING RESULT AS .00

Please help

Answers

Sign In or Register to comment.