min 3asec datediff mssql

Solutions on MaxInterview for min 3asec datediff mssql by the best coders in the world

showing results for - "min 3asec datediff mssql"
Iker
01 Jan 2018
1declare  @date1 datetime, @date2 datetime
2set @date1=DATEADD(s,-638,getdate())
3set @date2=GETDATE()
4
5select convert(char(8),dateadd(s,datediff(s,@date1,@date2),'1900-1-1'),8)
6
similar questions
queries leading to this page
min 3asec datediff mssql