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 vote190 views1 answer
Alternative for LIMIT sql
SQL
1 vote118 views1 answer
Oracle compile schema
SQL
2 votes128 views1 answer
SQL IF ELSE
SQL
0 vote143 views1 answer
Mysql vs sql server performance benchmark
SQL
1 vote158 views1 answer
Varchar plsql
SQL
0 vote131 views1 answer
Case insensitive sql
SQL
15 votes143 views3 answers
Mysql update add to existing value
SQL
0 vote140 views1 answer
Mysql shell ERROR: Not connected.
SQL
2 votes186 views3 answers
3 days back in sql server
SQL
0 vote151 views1 answer
Add two days to current date in sql when creating tables
SQL