How to change the Date format of a date filed in snowflake?

Question

i am looking to change in snowflake the values of a date field which has for example this format: 2/10/17, 11/1/17, 12/18/19 to this format: 20010408, 20121226, 20010304.

Thank you

Answer 1

I will assume that your date field is a string, since neither of those date formats are actually how Snowflake stores a date. But to convert, you'd do something like this:

SELECT TO_VARCHAR(TO_DATE('2/10/17','MM/DD/YY),'YYYYMMDD');