SQL MM/dd/yyyy format

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

SQL query to convert DD/MM/YYYY to YYYY-MM-DD

SELECT CONVERT(varchar(10), CONVERT(date, '13/12/2016', 103), 120)

-1

Source: social.technet.microsoft.com

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

6 votes352 views3 answers
Commit in sql
SQL
0 vote379 views1 answer
Selecting duplicates
SQL
0 vote378 views2 answers
Generate sql trigger through ef migration
SQL
0 vote367 views1 answer
Update sql sintax
SQL
0 vote355 views1 answer
Mysql insert into select with recursive
SQL
5 votes363 views2 answers
Create function postgresql
SQL
0 vote341 views1 answer
Composit key in sql
SQL
0 vote368 views1 answer
Mysql date time string format for marshmellow field schema
SQL
7 votes329 views1 answer
Grant schema permissions postgres
SQL
0 vote341 views2 answers
How to list all values of a column that start with a letter in sql
SQL