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

3 votes316 views1 answer
Difference sql vs mysql
SQL
0 vote385 views1 answer
How to find date from date table in sql
SQL
4 votes335 views1 answer
Is there any command to change postgres password
SQL
0 vote354 views1 answer
Sql gather statistics to increase performance
SQL
40 votes382 views6 answers
Update table mysql
SQL
6 votes353 views1 answer
Oracle pl sql source
SQL
1 vote332 views1 answer
Mysql batch insert
SQL
0 vote327 views1 answer
Xampp mysql version
SQL
1 vote295 views1 answer
Insert into sql
SQL
0 vote319 views1 answer
Oracle query to see what scema i am working in
SQL