Get the date in YYYY-MM-DD format in SQL Server.

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