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 vote130 views1 answer
Distinct data types in a table sql query
SQL
1 vote132 views1 answer
How to select random rows from table
SQL
0 vote152 views1 answer
T sql dynamic top n query
SQL
11 votes136 views1 answer
How to get ddl for materialized view
SQL
19 votes133 views2 answers
Mysql add column after another
SQL
17 votes144 views3 answers
How to change a collumn name in sql
SQL
3 votes145 views3 answers
Mysql declare variable
SQL
4 votes136 views1 answer
Oracle select first 10 rows
SQL
1 vote150 views1 answer
Last 24 HOUR data in mysql
SQL
0 vote122 views1 answer
Prepared statement mysql java delete selected rows
SQL