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

10 votes380 views3 answers
Join multiple tables sql
SQL
0 vote377 views1 answer
Varchar2 length in oracle
SQL
0 vote412 views1 answer
Sql statement show all emails with dome
SQL
0 vote380 views1 answer
What is server_default = func.now() in sqlalchemy
SQL
4 votes345 views1 answer
Postgresql change default value
SQL
0 vote376 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
0 vote413 views2 answers
How to truncate all table in mysql workbench
SQL
1 vote352 views2 answers
Oracle list partitioned tables
SQL
0 vote369 views1 answer
Postgresql create query
SQL
2 votes374 views1 answer
Could not find driver (SQL: select * from information_schema.tables where table_schema = francis_koopmart and table_name = migrations and table_type = 'BASE TABLE')
SQL