-- Using tsql to figure out how long until TRON:LEGACY

DECLARE @tron datetime,

@tron_legacy datetime

SET @tron = '7/9/1982 12:00:00'

SET @tron_legacy = '12/17/2010 12:00:00'

SELECT CAST( DATEDIFF( DD, GETDATE(), @tron_legacy ) as varchar(2) ) + ' of' + CAST ( DATEDIFF( DD, @tron, @tron_legacy ) AS VARCHAR(1000) ) + ' days remaining' as 'How long until TRON:LEGACY?'

-- returns

-- 2 of10388 days remaining