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 vote273 views2 answers
How to update date in oracle
SQL
0 vote274 views1 answer
How many rows affected in sqllite
SQL
0 vote266 views1 answer
Forcefully delete a row in mysql which has references
SQL
0 vote286 views4 answers
How to connect form to database
SQL
0 vote269 views1 answer
Porcentaje sql
SQL
2 votes316 views1 answer
Pdo mysql insert
SQL
0 vote256 views1 answer
Import all databases mysql
SQL
0 vote282 views1 answer
Mysql subtract month from timestamp
SQL
1 vote265 views1 answer
Mysql count words
SQL
0 vote289 views1 answer
T-SQL MERGE with condition what is not matched?
SQL