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

0 vote178 views1 answer
Where name ends in SQL
SQL
14 votes172 views3 answers
Alter foreign key
SQL
32 votes170 views6 answers
Insert select
SQL
29 votes171 views5 answers
Mysql show table structure
SQL
1 vote182 views1 answer
Mysql return if it contains
SQL
0 vote170 views1 answer
MySql count occurences more than"
SQL
1 vote215 views1 answer
Postgresql float 2 decimal places
SQL
0 vote242 views1 answer
Sqlite schema structure of a relational database
SQL
1 vote141 views1 answer
Convert money to varchar sql server
SQL
1 vote186 views1 answer
Trim leading zeros in sql
SQL