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 vote143 views1 answer
Sql server datetime to string
SQL
9 votes145 views3 answers
Sql delete where in
SQL
0 vote146 views1 answer
Mysql illegal mix of collations for operation 'concat'
SQL
2 votes141 views2 answers
Sql first character
SQL
0 vote188 views1 answer
Capabilities of sql select statements
SQL
0 vote152 views1 answer
Get schema of table sql
SQL
0 vote174 views1 answer
How to enable mysql 5.7 root user password on linux
SQL
0 vote133 views1 answer
Sql beginning of previous month
SQL
0 vote306 views1 answer
Current month transactions in mysql
SQL
0 vote183 views1 answer
Generate random & unique mysql string
SQL