Even if the date/time came in as 10/17/2007 05:00:00 you still wind up with a TimeSpan of 12 hours and 12 minutes (05:00 AM is just what i was playing around with in Query Analyzer).
In any event, this will give you a whole number of minutes passed between the 2 times:
DECLARE @now datetime, @whateverdate datetime
SET @now = GETDATE()
set @whateverdate = '10/17/2007 15:00:00'
SELECT DATEDIFF(mi, 0, @now - @whateverdate)
Read this if you want to know how to get a correct reply for your question:
Technical Editor for:
Beginning Visual C# 2008
Professional Search Engine Optimization with ASP.NET
Professional IIS 7 and ASP.NET Integrated Programming
Wrox Blox: Introduction to Google Gears
Wrox Blox: Create Amazing Custom User Interfaces with WPF and .NET 3.0