04 Oct 19 ·  nVector in Snowflake ·        Bookmark ·  Report ·  More actions.. Lock comments ·  Pin thread

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;


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