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 vote178 views3 answers
How to filter repeated same result using sql query
SQL
2 votes206 views2 answers
Maximum execution time of 360 seconds exceeded
SQL
2 votes186 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL
0 vote204 views1 answer
Sql query to return field name of a table
SQL
0 vote193 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL
0 vote187 views1 answer
Mysql multiple primary keys
SQL
3 votes187 views1 answer
How to find names includes in sql
SQL
-1 vote231 views1 answer
Search all sql tables for a value
SQL
3 votes187 views2 answers
Df to sql pandas sql achemy
SQL
0 vote187 views1 answer
Inspecting a column unique/distinct values in SQL
SQL