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)

This article is tagged with: Sql convert date to string yyyy-mm-dd and mysql