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 vote232 views1 answer
Mysqlimport
SQL
0 vote179 views1 answer
Mysql workbench format date
SQL
0 vote182 views1 answer
Mysql query to check record exists in database table or not
SQL
0 vote148 views1 answer
Raven ql select count
SQL
1 vote178 views1 answer
Mysql check table exists
SQL
11 votes209 views3 answers
Sql line numbers
SQL
0 vote181 views1 answer
Insert or update cassandra
SQL
4 votes176 views1 answer
Delete record mysql query
SQL
0 vote191 views1 answer
Update All tables COLLATE DATABASE_DEFAULT
SQL
0 vote203 views1 answer
Unable to convert mysql date/time value to system.datetime
SQL