Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

sign value

Hi,

I need to load data to redshift table.

I have a value like 5.01E+12 . I would like to convert and upload data to redshift like 5010000000000.

Thanks,

Mathan

1 Community Answers

Matillion Agent  

Kalyan Arangam —

Hi Mathan,

Assuming you are retrieving this value in a VARCHAR column, you may use the calculator component to try and cast it as numeric.
The following worked for me.

select cast('5.01E+12'  as numeric)

If the above doesn’t help, please explore CAST/Convert or other mathematical functions in Redshift.

Best
Kalyan

Post Your Community Answer

To add an answer please login