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

4 votes123 views1 answer
Mysql insert from local csv
SQL
0 vote171 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL
0 vote134 views1 answer
Python list from sql
SQL
0 vote134 views1 answer
Hive batch drop table
SQL
10 votes138 views4 answers
Mysql one week ago
SQL
0 vote140 views1 answer
Oracle concat datetime
SQL
2 votes148 views1 answer
Query to find table size in oracle 12c
SQL
0 vote141 views1 answer
Sql select all records from all tables where not empty
SQL
0 vote152 views1 answer
The fetch keyword oracle
SQL
0 vote134 views2 answers
Sql select inside select
SQL