06 Oct 19 · npack · #Snowflake ·   Bookmark   ×

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;

npack

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

Copied