Cast as Integer syntax in Snowflake

Use the cast function to convert a string to a Integer / Number format:

SELECT CAST('123' AS INTEGER) AS Emp_Id;

SELECT CAST('123' AS NUMBER) AS Emp_Id;

posted on 06 Oct 19

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds