Answers for "date format in sql statement"

date format in sql

SELECT CONVERT(VARCHAR, GETDATE(),101) AS DATE
SELECT CONVERT(VARCHAR, GETDATE(),102) AS DATE
SELECT CONVERT(VARCHAR, GETDATE(),103) AS DATE
SELECT CONVERT(VARCHAR, GETDATE(),104) AS DATE
SELECT CONVERT(VARCHAR, GETDATE(),105) AS DATE
SELECT CONVERT(VARCHAR, GETDATE(),106) AS DATE

SELECT DATE = FORMAT(GETDATE(), 'dd-MM-yyyy')

Posted by: Guest on June-24-2021

SQL Date Format

SELECT FORMAT(dbo.column, 'M/dd/yyyy')

Posted by: Guest on December-09-2020

Code answers related to "date format in sql statement"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "date format in sql statement"

Code answers related to "date format in sql statement"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "date format in sql statement"

Code answers related to "date format in sql statement"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us