Answers for "date to string sql"

date to string sql

SELECT 
    TO_CHAR(SYSDATE, 'YYYY-MM-DD') 
FROM 
    dual;
Code language: SQL (Structured Query Language) (sql)

Posted by: Guest on March-10-2022

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

Code answers related to "date to string sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "date to string sql"

Code answers related to "date to string sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "date to string sql"

Code answers related to "date to string sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us