26-datediff.sql

SQL Server 2005基础教程一书的源代码.

DECLARE @FirstTime datetime, @SecondTime datetime
SET @FirstTime = '24 March 2006 3:00 PM'
SET @SecondTime = '24 March 2006 3:33PM'
SELECT DATEDIFF(ms,@FirstTime,@SecondTime)