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

0 vote255 views1 answer
Oracle dynamic select into
SQL
0 vote247 views1 answer
Helptext in sql
SQL
0 vote227 views2 answers
Postgresql get long running queries
SQL
1 vote258 views1 answer
Group_concat order by
SQL
0 vote238 views1 answer
Sqlalchemy query return only n results
SQL
1 vote247 views1 answer
Second last highest id in sql
SQL
21 votes253 views1 answer
Cheatsheet for sql
SQL
15 votes259 views6 answers
Laravel db transaction
SQL
0 vote236 views1 answer
Install sql server windows 10
SQL
0 vote228 views1 answer
Tsql default value when no value returned by query
SQL