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

1 vote99 views1 answer
Mysql datetime with timezone offset
SQL
1 vote140 views1 answer
Hangfire clear all jobs
SQL
0 vote160 views1 answer
Mysql delete entire row on condition
SQL
0 vote104 views1 answer
Oracle free up space in tablespace
SQL
0 vote109 views1 answer
Move table to a different schema
SQL
0 vote135 views1 answer
Insert into table with only identity column
SQL
1 vote117 views3 answers
How to pass password to mysql command line
SQL
0 vote119 views1 answer
Ms sql filter all sympbol
SQL
3 votes133 views3 answers
Mysql auto increment after delete
SQL
0 vote114 views1 answer
How to query all tables mysql at the same time
SQL