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?
Results 1 to 4 of 4
Thread: to_char(number)Hybrid View
|
Click Here to Expand Forum to Full Width |