Min:sec datediff mssql

declare  @date1 datetime, @date2 datetime
set @date1=DATEADD(s,-638,getdate())
set @date2=GETDATE()

select convert(char(8),dateadd(s,datediff(s,@date1,@date2),'1900-1-1'),8)

Source: stackoverflow.com

Similar codes

0 vote145 views1 answer
Leftjoin in sql
SQL
13 votes127 views3 answers
Insert mysql ifile nto database
SQL
5 votes122 views1 answer
Pl sql asynchronous procedure calls
SQL
7 votes134 views2 answers
N highest salary in sql
SQL
0 vote137 views1 answer
Execute a stored procedure in another stored procedure in SQL server
SQL
0 vote135 views1 answer
Set engine to innodb
SQL
15 votes129 views6 answers
Psql
SQL
0 vote134 views1 answer
Flexible search query delete table
SQL
1 vote132 views3 answers
Drop unique key constraint in sql server
SQL
0 vote115 views1 answer
Partitioning in oracle-base
SQL