Sql server date format yyyy-mm-dd

SQL MM/dd/yyyy format

SELECT CONVERT(VARCHAR(11), GETDATE(), 101) AS [MM/DD/YYYY]

Sql convert date to string yyyy-mm-dd

select CONVERT(char(10), GetDate(),126)
/* 2020-12-23 */

Sql server date format yyyy-MM-ddThh:mm:ss

select REPLACE(convert(varchar, getdate() , 20), ' ', 'T')

Sql server date format yyyy-mm-dd

convert(varchar, [column_date], 20) --(date or datetime) to yyyy-MM-dd HH:mm:ss
convert(varchar, [column_date], 23) --(date or datetime) to yyyy-MM-dd

--ref https://www.mssqltips.com/sqlservertip/1145/date-and-time-conversions-using-sql-server/

-1

Similar codes

1 vote155 views1 answer
Postgresql substring last
SQL
2 votes168 views4 answers
2nd highest salary in mysql
SQL
1 vote178 views3 answers
Postgresql get difference between two dates
SQL
0 vote164 views1 answer
Drop database using terminal postgres
SQL
4 votes167 views2 answers
Bulk kill mysql processlist
SQL
9 votes145 views4 answers
How to remove duplicate in sql
SQL
57 votes1.8K views5 answers
How to create a new user in postgresql
SQL
0 vote166 views1 answer
Select into table variable
SQL
0 vote156 views1 answer
Mariadb errno 121
SQL
0 vote151 views1 answer
Forcefully delete a row in mysql which has references
SQL