SELECT CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(getDate())-1),getDate()),101)
Asked In: Many Interviews | Alert Moderator
Login to post response