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 vote205 views1 answer
Postgresql update to unique
SQL
2 votes200 views1 answer
Oracle generated column
SQL
3 votes207 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL
2 votes222 views1 answer
SELECT LOCKED FROM public.databasechangeloglock WHERE ID=1
SQL
1 vote235 views3 answers
How to create a table structure from another table in mysql
SQL
2 votes191 views1 answer
Ssh mysql port forwarding
SQL
0 vote197 views1 answer
Get number of rows in every table mysql
SQL
14 votes193 views1 answer
Excel
SQL
0 vote206 views1 answer
Mysql average from two table
SQL
-1 vote207 views1 answer
How to change the auto increment in existing table mysql
SQL