Answers for "sql data format"

SQL
-1

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
2

SQL Date Format

SELECT FORMAT(dbo.column, 'M/dd/yyyy')
Posted by: Guest on December-09-2020
1

sql date format

default date format of my sql - YYYY-MM-DD
Posted by: Guest on March-18-2021
0

sql server format datetime to short date

CONVERT ( data_type [ ( length ) ] , expression [ , style ] )
Posted by: Guest on June-17-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language