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 vote198 views1 answer
Update from select oracle
SQL
0 vote201 views7 answers
10 random questions use python and SQL
SQL
1 vote229 views1 answer
Join to find results not in another table
SQL
0 vote187 views1 answer
Fill up postgres db
SQL
0 vote227 views1 answer
Group by max date
SQL
9 votes181 views3 answers
Where in sql
SQL
0 vote181 views4 answers
Sql limit 1 offset 1
SQL
7 votes221 views1 answer
Sql pagination oracle
SQL
0 vote188 views1 answer
Insert set mysql
SQL
0 vote286 views1 answer
Microsoft sql server python connection
SQL