• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1684
  • Last Modified:

Convert ' 2.32204861111111E-02' to Float in Oracle...

I need to be able to convert a text string like...
'           2.32204861111111E-02'
To a float value in Oracle. I'll load the value into a staging table, so I'm looking for something like...

Select to_number(my_varchar,'9D9999999E99') from my_table

Which will return the float value.

Thanks for your help...

Geoff
0
gswitz
Asked:
gswitz
1 Solution
 
paquicubaCommented:
Try to_number()
0
 
chuchyyyCommented:
my_varchar is a string :

Select cast( my_varchar AS float ) from my_table return a float number
0
 
gswitzAuthor Commented:
:)

Look, there's the nose in front of my face! Who knew!
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now