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

14 votes262 views3 answers
SQL trim
SQL
2 votes267 views1 answer
Mysql virtual column
SQL
7 votes246 views1 answer
Grant schema permissions postgres
SQL
0 vote291 views1 answer
Mysql collation portugues brasil
SQL
0 vote273 views1 answer
Sql select upcoming birthdays
SQL
0 vote258 views1 answer
Mysql two joins
SQL
1 vote300 views1 answer
Backup mysql schema only
SQL
7 votes246 views4 answers
How to reset the identity column in sql server
SQL
5 votes266 views1 answer
Com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed
SQL
0 vote255 views1 answer
Services.AddDbContext DataSource Sqlite
SQL