This content was proof-read by Grammarly. You can Try Grammary for FREE
You can retreive the date in the YYYY-MM-DD format in SQL Server using the CONVERT method as shown in this code snippet.
How to get the date in YYYY-MM-DD format in SQL Server ?
SELECT CONVERT(char(10), GetDate(),126) as abundantcodedate