In Snowflake, how do I CAST CURRENT_TIMESTAMP up to the minute only?

Question

In Snowflake, how do I CAST CURRENT_TIMESTAMP up to the minute only. I don't want seconds, milliseconds, or timezone included in my result.

Answer 1

You can use TO_CHAR or TO_VARCHAR.

Query,

select to_char(current_timestamp(), 'YYYY-MM-DD HH24:MI') as new_dt;