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

Tags : database, How to, SQL Server, tips, tricks