TO_CHAR(0.56, '999990.9')  =  0.6

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

arrow
arrow
    全站熱搜

    Big Bear 發表在 痞客邦 留言(0) 人氣()