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;

nVector

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