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 vote149 views1 answer
If column value is null then in mysql
SQL
0 vote167 views1 answer
Sql server: concatinate column value without trailing or leading comma
SQL
0 vote153 views1 answer
Make parameters nullable in sql server
SQL
2 votes127 views1 answer
Ifnull postgres
SQL
2 votes169 views1 answer
Python sql
SQL
10 votes148 views3 answers
How to fetch first 5 characters in sql
SQL
0 vote131 views1 answer
Query on date sqlite flutter
SQL
0 vote164 views1 answer
Openquery join two tables
SQL
1 vote163 views1 answer
Psql connect
SQL
8 votes185 views4 answers
Convert date to dd/mm/yyyy sql
SQL