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 vote277 views1 answer
Sql list dates between two dates
SQL
0 vote259 views2 answers
Postgresql get long running queries
SQL
-3 votes298 views2 answers
How to enable mysql authentication on ubuntu 18.04
SQL
1 vote273 views2 answers
Postgres copy table from one schema to another
SQL
0 vote256 views1 answer
Drop all data from tables
SQL
8 votes283 views1 answer
Sql limit results returned
SQL
2 votes292 views1 answer
Postgresql update sequence next value
SQL
1 vote302 views1 answer
Psql view enum values
SQL
0 vote283 views1 answer
Oracle for loop on list
SQL
1 vote287 views1 answer
Setval pgsql
SQL