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 votes267 views1 answer
What are the data types in sql
SQL
0 vote255 views1 answer
Forcefully delete a row in mysql which has references
SQL
0 vote264 views1 answer
Org.apache.spark.sql.avro.IncompatibleSchemaException: Unexpected type org.apache.spark.ml.linalg.VectorUDT
SQL
15 votes277 views4 answers
Mysql where value is null
SQL
0 vote289 views1 answer
One table with another
SQL
150 votes485 views10 answers
Grepper
SQL
0 vote226 views1 answer
Flask_sqlalchemy install
SQL
0 vote262 views1 answer
Cast float mysql
SQL
0 vote244 views1 answer
Alter session set nls_language french
SQL
0 vote313 views1 answer
How to use sqlcommand
SQL