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

8 votes207 views2 answers
Sqlsrv default port
SQL
1 vote166 views1 answer
Apex ORA-20999
SQL
-1 vote155 views1 answer
Plsql while
SQL
0 vote158 views2 answers
Get top 1 row of each group
SQL
0 vote215 views1 answer
Oracle current date minus 1 day
SQL
0 vote205 views4 answers
Rownum in sql
SQL
0 vote164 views1 answer
Start and stop mysql
SQL
0 vote160 views1 answer
IIF
SQL
2 votes115 views1 answer
Sql view column data type
SQL
0 vote178 views1 answer
Mysql group by range
SQL