GETDATE in Snowflake in not working for conversion

Question

In SQL we can do below

select convert(varchar, getdate(), 101)

Anything same in Snowflake for GETDATE ?

Thank You.

Answer 1

How about using CURRENT_DATE?

SELECT TO_VARCHAR(CURRENT_DATE, 'MM/DD/YYYY' ) ,
       TO_VARCHAR(CURRENT_DATE, 'DD-MM-YYYY' );