想要从字符格式转换为带小数的数字格式 [英] Want to convert from character format to number format with decimal

问题描述

想要将字符格式(00001000000)转换为10000.00.请帮助我.

want to convert character format (00001000000) as 10000.00. Please help me.

我已经尝试过

select to_number('00012300','9999999999.99','nls_numeric_characters = ''.,''') from dual

此脚本，但它只能显示12300，实际上我想查看为123.000

this script but it can show only 12300, actually i want to view as 123.000

推荐答案

好吧，您可以使用以下方法将值转换为数字

Well, you can convert your value to a number using

select to_number('00012300') from dual;

似乎您除以100.

所以

select to_number('00012300') / 100 from dual;

如果您要显示两位小数，请使用格式再次返回到varchar

If you want to display two decimals, back to a varchar again, with a format

select to_char(to_number('00012300') / 100, '999999D99')  from dual;

这篇关于想要从字符格式转换为带小数的数字格式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！