/SQL/Hour and minute between two datatime sql

Hour and minute between two datatime sql

Declare @InTime datetime='2017-11-27 10:00:00',
 @OutTime datetime='2017-11-27 11:15:00'

 SELECT CONVERT(varchar(5),DATEADD(minute,DATEDIFF(minute,@InTime,@OutTime),0), 114)
 -----------
 Result
 01:15

Source: stackoverflow.com

Similar codes

3 votes304 views2 answers
How to list columns for particular tables in postgresql
SQL
0 vote293 views2 answers
Sql join on wildcard
SQL
0 vote295 views1 answer
In mysql workbench contnent not feching
SQL
2 votes294 views1 answer
Columns Present in a table
SQL
0 vote318 views1 answer
Nvl2 syntax
SQL
1 vote286 views1 answer
User privileges postgresql information_schema
SQL
9 votes285 views4 answers
How to remove duplicate in sql
SQL
8 votes304 views1 answer
Sql remove leading spaces
SQL
0 vote277 views1 answer
How to count with except in psql
SQL
0 vote299 views1 answer
Multiple left join mysql
SQL