SELECT CONVERT (DATE, GETDATE()) AS 'yyyy-MM-dd format'
SELECT FORMAT(GETDATE(),'yyyy-MM-dd') AS 'yyyy-MM-dd format'
Login to post response