This article is tagged with:
Sql convert date to string yyyy-mm-dd
and mysql
sql convert date to string yyyy-mm-dd
select CONVERT(char(10), GetDate(),126)
/* 2020-12-23 */
sql server convert date to string yyyymmdd
DECLARE @v DATE= '3/15/2013'
SELECT CONVERT(VARCHAR(8), @v, 112)
sql server format date
convert (varchar , getdate()-1 , 112)