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 vote190 views1 answer
Postgresql update auto_increment value
SQL
4 votes228 views1 answer
Oracle error line
SQL
0 vote217 views7 answers
Les jointures sql server
SQL
2 votes215 views1 answer
Set column to not null mysql
SQL
19 votes228 views6 answers
Sql drop table if exists
SQL
0 vote207 views1 answer
Google sheets filter rows above current cell
SQL
0 vote227 views1 answer
T-SQL - Where Used List (Table/View)
SQL
0 vote302 views1 answer
Mysql show schema
SQL
0 vote216 views1 answer
Mysql procedure between two tables
SQL
16 votes200 views2 answers
Gremove folder from git
SQL