to_char(number)

Hi, all, I am using the to_char function as following:

SELECT TO_CHAR(SUM(N_SHIPPED_QTY*N_TMSS_UNIT_BYG_PRC),'9G999D99') FROM TT_INVC_DET;

I don't understand why the return result is #######. Is
it because of my SQL+ setting?

You probably have to modify your NUMBER FORMAT MODEL to increase enough number of digits to display the result.

like '999G999G999D99'

Do you have any coluimn length set for this column?
Try "clear columns" before running the query.

Sanjay

D 99D99 decimal character
G 9G99 group separator

(from RevealNet)

TRY

SELECT TO_CHAR(SUM(N_SHIPPED_QTY*N_TMSS_UNIT_BYG_PRC),'99999G999D99') FROM TT_INVC_DET


BECAUSE IN YOUR DATABASE , THE
N_SHIPPED_QTY*N_TMSS_UNIT_BYG_PRC

AMOUNT IS BIGGER THAN 9999 , SO IT'S NOT DISPLAYED PROPERLY