04 Oct 19 · npack ·       Add to Favorites  

DATEDIFF command syntax in Snowflake


Calculates the difference between two date, time, or timestamp expressions

select datediff(hour, column1, column2) diff_hours,
datediff(minute, column1, column2) diff_minutes,
datediff(second, column1, column2) diff_seconds from tablename;

npack

posted on 04 Oct 19

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds

Copied