Sql server datetime to string

DECLARE @dt DATETIME = '2019-12-31 14:43:35.863';

SELECT 
    CONVERT(VARCHAR(20),@dt,0) s1,
    CONVERT(VARCHAR(20),@dt,100) s2;

=========================================
                 OUTPUT
=========================================
s1                   s2
-------------------- --------------------
Dec 31 2019  2:43PM  Dec 31 2019  2:43PM

(1 row affected)

Source: sqlservertutorial.net

Similar codes

0 vote179 views1 answer
Multiple left join mysql
SQL
0 vote188 views1 answer
Sql create text column limited values
SQL
0 vote200 views1 answer
How to open mysql in docker
SQL
17 votes192 views2 answers
Mysql date to string
SQL
0 vote201 views1 answer
Mysql conf.d exampel
SQL
0 vote208 views1 answer
Compare field sql server
SQL
0 vote199 views1 answer
Mysql pad zeros
SQL
0 vote201 views1 answer
Unique element in sql
SQL
0 vote211 views2 answers
How to prevent sql injection in java
SQL
12 votes186 views10 answers
Google
SQL