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

6 votes112 views5 answers
Sql add months to date
SQL
12 votes138 views6 answers
Distinct in sql server
SQL
0 vote100 views1 answer
Order by ip address sql
SQL
0 vote95 views1 answer
Sql beginning of previous month
SQL
0 vote111 views1 answer
Mysql backup certain tables workbench
SQL
17 votes98 views4 answers
Show tables sql server
SQL
0 vote105 views2 answers
How to find max and min salary in sql
SQL
0 vote111 views1 answer
Oracle cpu metric
SQL
0 vote112 views1 answer
Mysql check if lowercase
SQL
0 vote125 views1 answer
Time data type in mysql
SQL