All Forums Database
cca8380 3 posts Joined 07/15
08 Sep 2015
Convert scientific notation to decimal

I currently have a char field that contains scientific notation values. I would like to convert these to decimal.
Thanks in advance for your help!!
Current format                           Needed Format
-1.9178464696202265E-2 -->     -0.01917846469620226500

dnoeth 4628 posts Joined 11/04
08 Sep 2015

CAST(col AS NUMBER) should work


Glass 225 posts Joined 04/10
08 Sep 2015


sel Cast('-1.9178464696202265E-2' as Decimal(20,20));


You must sign in to leave a comment.