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

2 votes123 views2 answers
Sql query to list all tables in a database sql server
SQL
0 vote115 views1 answer
Shell script to log mysql cpu usage
SQL
0 vote110 views1 answer
Sql menampilkan data tabel
SQL
5 votes107 views1 answer
Oracle get nls settings
SQL
0 vote119 views1 answer
Sql server select top 2 of each group
SQL
6 votes110 views1 answer
Oracle rank() over (partition)
SQL
0 vote113 views1 answer
Heidisql check how much space a row
SQL
1 vote110 views1 answer
Show table columns
SQL
24 votes104 views2 answers
Alter table delete column
SQL
0 vote125 views2 answers
Mysql dump database tables only
SQL