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 vote173 views1 answer
Executescalar in sql server
SQL
0 vote184 views1 answer
Search from comma separated values in sql server
SQL
1 vote179 views2 answers
Changes not showing on website server odoo
SQL
0 vote177 views1 answer
What is ssrs and ssis in sql server
SQL
3 votes190 views2 answers
Find string in stored procedure sql server
SQL
11 votes188 views1 answer
Oracle insert into where
SQL
0 vote178 views1 answer
Execute a stored procedure in another stored procedure in SQL server
SQL
3 votes138 views1 answer
Postgresql where current year
SQL
12 votes182 views2 answers
Update column data type postgres
SQL
35 votes194 views5 answers
Sql alter column
SQL