Please try this.

DATEADD( HH, 17, CAST(CAST(DATEA DD(DAY,-1,GETDATE()) AS INT) AS DATETIME))

-bala