如下所示,前面少个0
SQL>select money from users where username ='LEI';
money
---------
http://www.cndba.cn/Expect-le/article/125
.3256
http://www.cndba.cn/Expect-le/article/125
http://www.cndba.cn/Expect-le/article/125
解决方法:
SQL>select to_char(money ,'fm9999999990.00') from users where username ='LEI';http://www.cndba.cn/Expect-le/article/125http://www.cndba.cn/Expect-le/article/125
money
http://www.cndba.cn/Expect-le/article/125
---------
http://www.cndba.cn/Expect-le/article/125
http://www.cndba.cn/Expect-le/article/125
0.3256
http://www.cndba.cn/Expect-le/article/125
http://www.cndba.cn/Expect-le/article/125
版权声明:本文为博主原创文章,未经博主允许不得转载。