I have an expression
CAST((time_in - time_out) as time) ,
where time_in and time_out are datetime . The expression returns 01:48:00.0000000 .

How can I count the number of minutes to return 108?

    1 answer 1

    With the help of the function DATEDIFF , CAST not needed here.

     SELECT DATEDIFF(MI, time_in, time_out);