DECLARE @Christmas datetime

select @Christmas = '2016-12-25 00:00:00'

select convert(varchar (2),day(dateadd(d,-day(Getdate()),@Christmas)))+ ' Days, ' +

convert(varchar,24 - datepart(HH, getdate())) +' Hours and ' +

convert(varchar (2),60 - datepart(mi, getdate()))+ ' Minutes til Christmas'