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 vote357 views1 answer
Sql count value greater than
SQL
0 vote410 views1 answer
Sqlite display data in separated columns
SQL
16 votes334 views3 answers
MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote303 views1 answer
Mysql Error Code: 1005
SQL
0 vote319 views1 answer
Mysql return column names when table is empty
SQL
0 vote332 views1 answer
Postgresql replace html tags from string
SQL
0 vote303 views1 answer
Order by monthly in sql
SQL
1 vote340 views1 answer
Oracle get current schema
SQL
2 votes298 views4 answers
ModuleNotFoundError: No module named 'mysql'
SQL
0 vote301 views1 answer
Debian 10 install postgresql 2ndquadrant
SQL