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 vote128 views3 answers
Remove folders from remote git
SQL
0 vote141 views4 answers
How to connect form to database
SQL
16 votes148 views6 answers
Insert sql
SQL
0 vote132 views1 answer
Mysql add to value
SQL
0 vote163 views1 answer
Sql insert query list of dictionaries
SQL
5 votes92 views1 answer
Mongodb vs
SQL
0 vote145 views1 answer
Sql server beginning of month
SQL
0 vote158 views1 answer
Postgresql port 5432 not open
SQL
0 vote151 views1 answer
Template MySQL Zabbix agent
SQL
5 votes152 views1 answer
Oracle list functions
SQL