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 vote249 views1 answer
Sql cmd no truncate
SQL
0 vote216 views1 answer
Print orcale
SQL
1 vote239 views1 answer
Sql first
SQL
14 votes230 views3 answers
This is incompatible with sql_mode=only_full_group_by laravel
SQL
5 votes225 views1 answer
Ignore duplicate rows in sqlite
SQL
1 vote220 views1 answer
Oracle index partition
SQL
0 vote254 views1 answer
Delete hangfire retries list
SQL
21 votes227 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
0 vote239 views1 answer
Oracle decode
SQL
0 vote213 views1 answer
Como verificar registros duplicados no sql postgresql
SQL