Snowflake date format change

Question

Is there an easy way convert a date format from ('2020-11-17') to November 17,2020 in snowflake.

Thanks

Answer 1

You should consider using:

TO_CHAR(date, 'MMMM DD yyyy')

Answer 2

I SOLVED THIS PROBLEM USING BELOW SYNTAX:

TO_CHAR(date,'MMMM')||' '||TO_CHAR(date,'DD')||','||TO_CHAR(date,'yyyy')