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

4 votes255 views3 answers
Postgres drop all tables
SQL
0 vote207 views1 answer
Window function to forward fill
SQL
2 votes206 views2 answers
Mysql find max value row
SQL
1 vote242 views1 answer
Postgresql append array
SQL
0 vote193 views1 answer
Import big data to mysql
SQL
150 votes552 views10 answers
Grepper
SQL
0 vote198 views1 answer
Insert overwrite table in mysql in nifi
SQL
25 votes198 views6 answers
Sql update query
SQL
1 vote214 views1 answer
Mysql find tables with column name
SQL
1 vote207 views1 answer
Sql into vs insert into
SQL