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 vote306 views1 answer
Mysql show foreign keys column
SQL
5 votes341 views2 answers
To date oracle
SQL
1 vote379 views1 answer
Oracle drop temporary table
SQL
1 vote318 views1 answer
Select inside insert query
SQL
1 vote314 views1 answer
Select from one table where not on the other
SQL
0 vote318 views1 answer
Unique index in mysql
SQL
17 votes350 views6 answers
Change column name in sql
SQL
1 vote354 views2 answers
One to one and one to many relationship
SQL
1 vote338 views1 answer
Sql order by where condition
SQL
0 vote337 views2 answers
Add new column after in sql
SQL