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 vote218 views5 answers
Left join sql
SQL
0 vote176 views1 answer
Sql menampilkan data tabel
SQL
0 vote172 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
10 votes185 views1 answer
Oracle view dependencies
SQL
0 vote171 views1 answer
Create new schema mysql
SQL
-1 vote185 views1 answer
Su: Authentication failure mysql
SQL
7 votes179 views2 answers
Get database size mysql
SQL
0 vote154 views1 answer
Alter session set nls_language french
SQL
7 votes164 views1 answer
Safe mode mysql
SQL
0 vote179 views1 answer
Frename oracle
SQL