I want to return the the date for the day before my query runs but at a specific time. The time is not midnight, so:

convert(varchar (19),getdate() and '08:00:00',101)

does not work. Instead I want to return the day before at 8am.

Thanks.