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

0 vote352 views1 answer
Sql today at midnight
SQL
0 vote333 views1 answer
Mysql Digital Ocean connection problems
SQL
0 vote344 views1 answer
How to install postgresql on wsl
SQL
1 vote353 views1 answer
Round one decimal place mysql
SQL
0 vote343 views1 answer
How to query without duplicate rows in sql
SQL
0 vote362 views1 answer
Trigger vérifier stock
SQL
1 vote324 views1 answer
Importance of comment in mysql
SQL
9 votes341 views2 answers
Sql limit to 5 results
SQL
0 vote299 views1 answer
Linux upload database to mysql
SQL
0 vote319 views1 answer
Postgresql isnull with max
SQL