• SELECT convert(varchar,(cast(dateadd(d,-1,GETDATE())AS date)),112)