How to get the number of hours between the two dates in sql

Question

How to get the number of hours between the two dates in SQL Server

Example:

staffing_start_date (2017-08-01 06:00:00.00000)
staffing_end_dt (2017-08-01 18:00:00.00000)

Answer 1

You would use datediff():

select datediff(hour, staffing_start_date, staffing_end_date)