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

9 votes336 views4 answers
SQL Date Format
SQL
2 votes333 views1 answer
Postgresql create schema in specific database
SQL
2 votes299 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL
0 vote330 views1 answer
Show table details postgresql
SQL
1 vote303 views1 answer
Select not matching data from two tables
SQL
0 vote336 views1 answer
Oracle current timestamp
SQL
0 vote371 views1 answer
PGSQL dynamic table name
SQL
0 vote357 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
33 votes339 views6 answers
Change column name in mysql
SQL
1 vote315 views10 answers
Stack overflow
SQL