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 vote161 views1 answer
Best configuration for display table in sqlplus
SQL
123 votes935 views5 answers
Sql where contains
SQL
0 vote144 views1 answer
Oracle locked objects
SQL
0 vote154 views1 answer
Mysql sleep connections
SQL
7 votes150 views1 answer
Minecraft forge server host
SQL
6 votes148 views3 answers
How to delete table sqlite
SQL
3 votes172 views1 answer
Unsigned int in mysql
SQL
28 votes148 views4 answers
Delete database mysql
SQL
2 votes154 views2 answers
HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN
SQL
25 votes166 views5 answers
Uninstall mysql ubuntu
SQL