Zeitdifferenz

ID173
Link ReferenceNot set
Link CreditsNot set
Link Technical DocumentationNot set
PlCodelangT-SQL
PlGroupDatum, Zeit
PlItemTitleZeitdifferenz
Code--http://msdn.microsoft.com/de-de/library/ms189794.aspx

SELECT DATEDIFF(second, '2005-12-31 23:59:59.9999999', '2006-01-01 00:00:00.0000000') AS Seconds
Result Example