How to remove trailing zeroes in snowflake?-CodePudding

I have a column that is in INT type. I want to remove all the trailing zeroes and only have the number. The example below, should follow be: 3,10,20,20. I cannot have the 4 zeroes at the end.

Is there a way to do this?

CodePudding user response：

You could try casting your numeric data to integer, e.g.

SELECT AS_INTEGER(col) AS col
FROM yourTable;

CodePudding user response：

the 3dp is how floating point numbers print, thus you can cast to number SELECT column_name::number FROM table

If your data is a string/varient type, and not all values stored in your column always casts cleanly, in Snowflake you can hit error, with the TO_NUMBER or ::number forms, thus [TRY_TO_NUMBER][2] form should be used.