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!!
Example
Current format                           Needed Format
-1.9178464696202265E-2 -->     -0.01917846469620226500
 
 
 
 
 
 
 

dnoeth 4628 posts Joined 11/04
08 Sep 2015

CAST(col AS NUMBER) should work

Dieter

Glass 225 posts Joined 04/10
08 Sep 2015

Cast?
 

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

-0.01917846469620226500
 
Rglass

You must sign in to leave a comment.