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 vote117 views1 answer
Call function sql oracle
SQL
20 votes142 views4 answers
Reset auto increment in MySQL
SQL
0 vote150 views1 answer
Postgres full text search example
SQL
0 vote145 views1 answer
Oracle execute immediate quotes
SQL
10 votes165 views1 answer
Oracle all_dependencies
SQL
1 vote145 views1 answer
Oracle sequence last_number
SQL
0 vote135 views1 answer
Laravel eloquent get generated sql
SQL
0 vote138 views2 answers
How covert into int in maria db
SQL
0 vote170 views1 answer
Generate sql from specific migration ef core
SQL
3 votes150 views2 answers
Synonym oracle
SQL