Forum Discussion

Betty888's avatar
Betty888
Helper II
3 years ago
Solved

Redshift : How to convert a varchar column to decimal?

I need to convert a varchar col to decimal, but I can't do that with the cast function as I usually do, any advice please? Thanks !
Need Help
Tips and Tricks
  • Betty888's avatar
    Betty888
    3 years ago

    Thanks a lot for your reply ! 

    I was able to fix my issue by using the following statement in the "Source" : 

    to_number(myColumn,'9999999999D99') and this vonverted my varchar col to decimal.

    I hope this will help others. 

    Thanks again ! 

Betty888's avatar
Betty888
Helper II
3 years ago

Thanks a lot for your reply ! 

I was able to fix my issue by using the following statement in the "Source" : 

to_number(myColumn,'9999999999D99') and this vonverted my varchar col to decimal.

I hope this will help others. 

Thanks again !