Date format in sql

Sql server convert string to date

select Cast( '2021-09-22' as date ) as castedDate;
select convert(date,'20210922') as convertedDate;

SQL Date Format

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

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')

Similar codes

1 vote170 views1 answer
Mysql datetime with timezone offset
SQL
61 votes1.2K views6 answers
Mysql add column
SQL
0 vote194 views1 answer
Sql server convert to guid
SQL
0 vote184 views1 answer
Normalization in database
SQL
0 vote211 views1 answer
Sql server information_schema temp tables
SQL
0 vote190 views1 answer
Mysql default tls v1.3 ciphersuites
SQL
2 votes281 views1 answer
Oracle run_duration to number
SQL
0 vote168 views1 answer
How to connect pgadmin with excel
SQL
0 vote220 views1 answer
How to get distinct sets of rows using SQL (Oracle)?
SQL
1 vote192 views2 answers
Rebuild index sql server
SQL