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 vote266 views1 answer
Strat with in sql
SQL
0 vote289 views1 answer
Mysql select statement after index
SQL
0 vote298 views1 answer
Find how many table doesn't contain column in mysql
SQL
1 vote270 views2 answers
Sql where is not number
SQL
47 votes349 views6 answers
Add column mysql
SQL
0 vote303 views1 answer
Sql today at midnight
SQL
0 vote290 views1 answer
Mysql locate
SQL
1 vote303 views1 answer
Age postgres
SQL
4 votes316 views1 answer
Oracle nls_date_format
SQL
1 vote269 views1 answer
Mysql show data from table
SQL