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 vote212 views1 answer
Sql revert migration
SQL
3 votes178 views1 answer
Oracle nextval
SQL
0 vote213 views1 answer
Delete hangfire retries list
SQL
2 votes203 views3 answers
Sql truncate table
SQL
0 vote201 views1 answer
Mysql db dump restore max file size issue
SQL
1 vote192 views1 answer
Primary key with prefix sql
SQL
0 vote201 views1 answer
Show size of all tables postgres
SQL
0 vote175 views1 answer
Materialized view redshift
SQL
0 vote196 views3 answers
Drop multiple columns in sql
SQL
0 vote253 views1 answer
Sql to excel pgadmin
SQL