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 vote68 views1 answer
Mariadb list tables
SQL
0 vote135 views1 answer
ValueError: A string literal cannot contain NUL (0x00) characters.
SQL
2 votes118 views1 answer
Postgresql update sequence next value
SQL
1 vote131 views2 answers
Mysql grant all privileges on *.* to 'root'@' ' identified by
SQL
0 vote74 views1 answer
Plsql trigger insert update
SQL
0 vote138 views1 answer
Alling a function from PL/SQL in a select statement in ORACLE
SQL
2 votes121 views4 answers
List databases in sql server
SQL
0 vote112 views1 answer
Postgresql parse json array
SQL
3 votes133 views4 answers
Psql list tables in schema
SQL
0 vote122 views1 answer
Grant privileges of databse to user
SQL