Only Date NO Time

SELECT CONVERT (DATE, GETDATE()) AS 'yyyy-MM-dd format'

SELECT FORMAT(GETDATE(),'yyyy-MM-dd') AS 'yyyy-MM-dd format'