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 vote120 views1 answer
Sql where last 12 months
SQL
0 vote129 views1 answer
Create table in mysql mariadb primary key foreign key
SQL
0 vote125 views1 answer
MySql get primary keys of table
SQL
0 vote145 views1 answer
Oracle job session
SQL
0 vote146 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
1 vote152 views1 answer
Create new index takes long time postgresql
SQL
0 vote136 views1 answer
Sql server on mac m1
SQL
11 votes141 views2 answers
Having keyword sql
SQL
0 vote139 views1 answer
Reindex mssql table
SQL
0 vote124 views1 answer
Adonisjs ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL