Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

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 by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #datediff #mssql
ADD COMMENT
Topic
Name
4+7 =