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 vote115 views1 answer
Mysql column start with string
SQL
0 vote102 views1 answer
Vbscript create ADODB.Connection
SQL
15 votes112 views2 answers
Open postgress in terminal mac
SQL
0 vote128 views1 answer
What is default mysql database password in linux
SQL
1 vote108 views1 answer
Sql run multiple updates in one query
SQL
0 vote109 views1 answer
Oracle archivelog usage
SQL
0 vote106 views1 answer
Sql create text column limited values
SQL
0 vote101 views1 answer
Combine 2 columns search query mysql
SQL
0 vote105 views1 answer
Tsql delete all rows
SQL
0 vote100 views1 answer
R2dbc-postgresqldriver dependency
SQL