Convert scientific notation to decimal

Database

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

2 REPLIES
Senior Apprentice

Re: Convert scientific notation to decimal

CAST(col AS NUMBER) should work

Enthusiast

Re: Convert scientific notation to decimal

Cast?

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

-0.01917846469620226500

Rglass