The SQL time difference is converted to the format of several seconds

DECLARE @ t1 TIME, @ t2 TIME
SET @ t1 = '10: 10: 20'
SET @ t2 = '12: 10: 30'
SELECT @ t1, @ t2, CONVERT (varchar, DATEADD (s, DATEDIFF (s, @ t1, @ t2), 0), 108)

650) this. width = 650; "alt =" image "src =" http://b233.photo.store.qq.com/psb? /V10a3dkJ27eRNO/Q2BRN0b9gjKTR07myONXg. G99VoNu3p4 * 2 * Wy2iLb5I! /B/dMeQ4oraHAAA & bo = pwFQAAAAAAABANE! "Idx =" 0 "style =" margin: 0px; padding: 0px; border-width: 0px; border-style: none; vertical-align: top; "/>

650) this. width = 650; "alt =" image "src =" http://b232.photo.store.qq.com/psb? /V10a3dkJ27eRNO/slv98wajyy5A * QvUi35a * nH3JeJinJr6ndXnnlIjcvs! /B/dC4GTYpYLwAA & bo = * gbvaaaaabaiw! "Idx =" 1 "style =" margin: 0px; padding: 0px; border-width: 0px; border-style: none; vertical-align: top; "/>

This article is from the "Snow volcano" blog, please be sure to keep this source http://zw20045.blog.51cto.com/1135644/1290065