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 vote322 views1 answer
How to update random rows in sql
SQL
1 vote330 views1 answer
Sql drop with dependencies
SQL
0 vote337 views1 answer
Alter fedora mysql 8.0 user
SQL
0 vote329 views1 answer
Show create table in postgresql
SQL
1 vote324 views1 answer
Select from one table where not on the other
SQL
4 votes395 views1 answer
Fatal error: libpq-fe.h: No such file or directory
SQL
40 votes435 views4 answers
PostgreSQL add column
SQL
1 vote334 views1 answer
Count mysql server db tables
SQL
6 votes341 views2 answers
Stored procedure to delete data from table in mysql
SQL
6 votes387 views1 answer
Oracle trigger after logon on database
SQL