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

6 votes105 views2 answers
Return columns from table sql
SQL
33 votes115 views6 answers
Sql delete
SQL
8 votes104 views3 answers
Mysql alter table add index
SQL
0 vote132 views1 answer
How to pass list as parameter in SQL query
SQL
2 votes107 views1 answer
Mysql query unique column
SQL
5 votes107 views2 answers
Get number of columns sql
SQL
0 vote107 views1 answer
NLS_NCHAR_CHARACTERSET
SQL
0 vote104 views1 answer
Not between mysql
SQL
1 vote99 views1 answer
Round function in sql oracle
SQL
9 votes106 views1 answer
Mysql check date range
SQL