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 vote205 views1 answer
Mysql select from outside
SQL
1 vote204 views1 answer
Sql count value greater than
SQL
2 votes186 views1 answer
Mysql how to store lat,lng
SQL
1 vote189 views1 answer
Truncate left characters mysql
SQL
1 vote236 views3 answers
Default password of mysql
SQL
1 vote188 views1 answer
Database Queries
SQL
2 votes235 views2 answers
How to check data type in sql server
SQL
0 vote188 views1 answer
How to know if table in rigt or left in sql
SQL
0 vote206 views1 answer
Check if database exists sql
SQL
6 votes195 views1 answer
Oracle list primary key
SQL