Answers for "sql server datetime to string"

SQL

0

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)

Posted by: Guest on January-21-2022

Source

Code answers related to "sql server datetime to string"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#