3

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.

1 Answer 1

3

You can use TO_CHAR or TO_VARCHAR.

Query,

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.