declare @t1 datetime, @t2 datetime set @t1 = getdate() set @t2 = getdate() + 10 && 10 days from now select datediff( s, @t1, @t2 ) diffinseconds, datediff( mi, @t1, @t2 ) diffinminutes>I have two datetime fields, both with just times. I am trying to create a view that shows the timespan of time1 to time2. Any advice?