Code:
(dateadd(hour,8(dateadd(day,-1,convert(datetime,convert(date,getdate()),102)))))