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 vote268 views2 answers
Soql last year
SQL
4 votes264 views2 answers
Bulk kill mysql processlist
SQL
1 vote289 views2 answers
Truncate table sqlite
SQL
2 votes268 views1 answer
Oracle kill job by sid
SQL
0 vote256 views2 answers
List all the items that have not been part of any purchase order. sql
SQL
0 vote248 views1 answer
ORACLE SUBSTRING SYNTAX
SQL
20 votes256 views4 answers
Reset auto increment in MySQL
SQL
1 vote271 views1 answer
Hexadec to sql REDSHIFT
SQL
0 vote286 views1 answer
Sql today at midnight
SQL
0 vote278 views1 answer
How we can perform acid Operations in sql with examples
SQL