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 vote246 views1 answer
Can not connect to mysql server
SQL
3 votes401 views9 answers
Linq to sql converter online
SQL
0 vote255 views1 answer
Mysql default uuid
SQL
0 vote278 views1 answer
Load data infile mariadb slow
SQL
5 votes283 views4 answers
SQL Order of execution
SQL
0 vote257 views1 answer
Where field is null sql knex
SQL
0 vote256 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
0 vote235 views1 answer
How to check replication lag in mySQL
SQL
2 votes248 views2 answers
Mysql get time from datetime
SQL
5 votes261 views3 answers
MySql get fields of table
SQL