小數點 Format

小數點 Format



TO_CHAR(0, '999990.9')  =  0.0

ROUND(0.56, 1)  =  0.6 --還有 floor 無條件捨去

ROUND(0, 1)  =  0.0

TRUNC(0.56, 1)  =  0.5

TRUNC(0, 1)  =  0