You can also customize date-turn strings with format strings in SQL

This forum article (The Sadie Network Technology community) describes how SQL Server uses format string customization dates to convert to strings, for more information, see below:

DateTime.ToString ("Yyyy-mm-dd") is used in C #, and DateTime.ToString ("mm/dd/yyyy") is a way to convert dates and strings that are not available in SQL Server. As a function, the functions are similar to the datetime.tostring ("Formatprovide") method in. NET, but only the date part is implemented, and interested friends can supplement the time part.

create function fn_DateToString(@date datetime, @format varchar(20))
returns varchar(20)
as
begin
declare @result varchar(20)
select @result = (replace(replace(replace(@format,'yyyy','20'+substring(convert(char(8),@date,3),7,2)),'MM',substring(convert(char(8),@date,3),4,2)),'dd',substring(convert(char(8),@date,3),1,2)))
return @result
end

Use:

Select Dbo.fn_datetostring (getdate (), ' yyyy-mm-dd ')

Get results: 2005-07-12