SELECT CONVERT(VARCHAR(14),[DOB],101) AS 'DATE OF BIRTH' from EMP
SELECT CAST(GetDate() as DATE) AS 'Date'
Login to post response