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 vote352 views1 answer
How to add a Try/Catch to SQL Stored Procedure
SQL
8 votes358 views2 answers
Mysql grant all privileges to user from any host
SQL
1 vote293 views1 answer
Postgres kill pid
SQL
0 vote321 views1 answer
Commit transaction sql
SQL
14 votes403 views1 answer
How to export db from mysql
SQL
18 votes335 views4 answers
Uninstall mysql on ubuntu
SQL
0 vote318 views1 answer
Sql server count all tables rows
SQL
0 vote332 views1 answer
Mysql in clausule string array
SQL
0 vote410 views1 answer
Scheduled mysql database backup in linux
SQL
0 vote330 views1 answer
Mysql count unique in group statement
SQL