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

1 vote336 views1 answer
Find size of all DB's postgres
SQL
32 votes295 views6 answers
Insert into values select
SQL
0 vote292 views1 answer
Mysql start of today
SQL
1 vote293 views1 answer
Sql select contem uma palavra
SQL
0 vote304 views1 answer
Sql server check whether column has same equal values
SQL
1 vote293 views1 answer
Postgres convert exisiting column to text
SQL
16 votes328 views5 answers
Select last row in sql
SQL
3 votes313 views1 answer
Postgresql if null then 0
SQL
2 votes282 views1 answer
Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column \\ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote302 views1 answer
Query to generate query to drop primary keys or foreign key in ms sql server
SQL