怎么去价格中含分的

Question

  有很多商品的价格字段为 retail_pric
                100.00
                125.25
                130.20
                135.00
                ....
我用函数 SUBSTR(retail_pric,-1) 结果取的是最后不为0的那位，想实现取出价格中含分的，怎么取啊
             

Answer 1

select nvl(substr(to_char(retail_pric-floor(retail_pric)),4,1),0) from tablename;
这么长，汗。。坐等更简单的

Answer 2

(trunc(retail_pric,2)-trunc(retail_pric,1))*100
或
mod(retail_price*100,10)

Answer 3

select SUBSTR(retail_pric*100,-1)
from tab

Answer 4

nvl(substr(retail_pric,instr(retail_pric,'.')+2,1),0)